1, 题目描述:
2, 代码:
select title,count(distinct emp_no) as tfrom titlesgroup by title having t>=2;
来源: http://www.bubuko.com/infodetail-3399170.html