摘要：
两条关于生成排名的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 w... 阅读全文
posted @ 2006-10-16 11:22
Nina
阅读(309)
评论(1)
推荐(0)
浙公网安备 33010602011771号