按姓名分组查询
SELECT
username, COUNT(username) AS '人数'
FROM
t_user
GROUP BY
username
只查询姓名相同的人
SELECT
username, COUNT(username) AS '人数'
FROM
t_user
GROUP BY
username
HAVING
COUNT(username) > 1
按姓名分组查询
SELECT
username, COUNT(username) AS '人数'
FROM
t_user
GROUP BY
username
只查询姓名相同的人
SELECT
username, COUNT(username) AS '人数'
FROM
t_user
GROUP BY
username
HAVING
COUNT(username) > 1
转载于:https://www.cnblogs.com/bobi1234/p/7465971.html