一条简单Sql排序语句
name result date(日期)
zhang 奖
zhang 奖
Li 奖
Li 奖
Li 奖
Li 奖
Li 奖
需要按照每个人的奖惩次数多少进行排序
问题点数：20、回复次数：5Top
1 楼duanzilin（寻）回复于 2005-06-15 09:51:15 得分 5
select name,result,count(*) over(partition by name) num from table order by num,nameTop
2 楼guangli_zhang（广丽）回复于 2005-06-15 14:21:41 得分 5
select b.*
(select name,count(*) times from table1 where result ='奖'
group by name
order by times) a ,table1 b
where a.name = b.name
order by a.timesTop
3 楼heyixiang（子豚の愛人）回复于 2005-06-15 14:26:18 得分 5
select name,count(result) num from table group by name order by numTop
4 楼jmbd（江米糕）回复于 2005-06-15 15:10:22 得分 5
select name,result,icount
from(select name,result,count(result) as icount from test group by name,result)
order by icount descTop
5 楼jmbd（江米糕）回复于 2005-06-15 15:17:36 得分 0
上面语句可以简写成：
select name,result,count(result) as icount from test group by name,result
order by icount descTop
