摘要：--方法一： select a.id,a.SName,a.ClsNo,a.Score from Table1 a left join Table1 b on a.ClsNo=b.ClsNo and a.Score(select count(*) from Table1 where ClsNo=a.ClsNo and Score>a.Score) order by a.ClsNo... 阅读全文