排名的SQL语句
两条关于生成排名的SQL语句:
select name,score,(select count(*) from t where score>a.score)+1 from t a order by score
上面是：1,2,3,3,3,6,7... 下面是：1,2,3,3,3,4,5
select name,score,(select count(distinct score) from t where score>a.score)+1 from t a order by score
select name,score,(select count(*) from t where score>a.score)+1 from t a order by score
上面是：1,2,3,3,3,6,7... 下面是：1,2,3,3,3,4,5
select name,score,(select count(distinct score) from t where score>a.score)+1 from t a order by score
