--按成绩降序排列 取前10个即可
select a.number,b.class,b.score from st_score as a
join (
select top(1) t.class,t.score from (
select top 10 class,score from st_score
group by class
order by score desc) as t order by t.score) as b
on a.class=b.class and a.score=b.score
order by b.class,b.score desc
--查询10位同学的成绩(top 10)
selet top 10 * from st_score
--按成绩降序排列，也就是从高到低
order by score desc
--按年级分组
group by class
SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY class ORDER BY score DESC) AS NewPx, * FROM st_score) a WHERE a.NewPx=10
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024