SELECT
title,
COUNT(DISTINCT emp_no) t
FROM
titles
GROUP BY
title
HAVING
t >= 2
牛客SQL练习-14-从titles表获取按照title进行分组,每组个数大于等于2,给出title以及对应的数目t。 注意对于重复的emp_no进行忽略
最新推荐文章于 2021-03-11 17:53:15 发布
SELECT
title,
COUNT(DISTINCT emp_no) t
FROM
titles
GROUP BY
title
HAVING
t >= 2