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

Question

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

Answer 1

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

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

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