排序问题

[lionqun]

如何以一个表中某一字段的内容重复次数为排序依据？

比如Username字段出现“张三”四次，那么把这四条记录排在1，2，3，4位
出现“李四”出现三次，那么把这三条记录排在5，6，7位。

[愉快的登山者]

select * from table1 A
order by (select count(*) from table1 where sername = A.sername) desc

[愉快的登山者]

select * from table1 A
order by (select count(*) from table1 where sername = A.sername) desc

[zarge]

select * from table1 A
order by (select count(1) from table1 where Username = A.Username) desc

[mjhnet]

select * from table1 A
order by (select count(*) from table1 where sername = A.sername) desc, sername