MySQL用group by获取相同值的条数

select count(1) from (select count(1) from T_SC_UserManager GROUP BY pcName) T

 

注：后面的临时名字T必须得有。

 

衍生出来的，

（1）获取条数大于1的。
select count(1) as cnt from T_SC_UserManager GROUP BY pcName having cnt > 1;

（2）同时获取内容

select count(1) as cnt, empName from T_SC_UserManager GROUP BY pcName having cnt > 1;