SELECT
title,
COUNT(title) t
FROM
titles
GROUP BY
title
HAVING
t >= 2
牛客SQL练习-13-从titles表获取按照title进行分组,每组个数大于等于2,给出title以及对应的数目t
最新推荐文章于 2021-04-15 10:42:06 发布
SELECT
title,
COUNT(title) t
FROM
titles
GROUP BY
title
HAVING
t >= 2