select title,count(distinct(emp_no)) as t from titles group by title having t>=2; 和上一题的唯一区别就是加了distinct去重。