sql如何查询语句计算重复数据个数

Question

select DISTINCT mypage from deyebcount

如何写sql可以得到每一个行重复的个数呢？按照由大到小排列

Answer 1

sql 计算重复数据个数 可以使用 count 来统计例子personal表id name1 xm2 xm3 mx统计personal表中name为xm的个数select count(name) total from personal where name='xm'结果total2

Answer 2

DISTINCT 是去重复值!select count(mypage) as s from deyebcount group by mypage order by mypage desc;

Answer 3

select mypage,count(*) from deyebcount group by mypage order by mypage desc;

Answer 4

12select count(*),字段名 from 表名group by 字段名 having count(*)>1