使用SQL列出表中按Score排序的前三名的结果

发布网友发布时间：2022-04-10 15:50

共6个回答

热心网友时间：2022-04-10 17:19

select top 3 with ties name,score from record order by score

(由低分到高分排列)
select top 3 with ties name,score from record order by score desc(由高分到低分排列)

with ties 的用法:对于TOP来说with ties 很重要,
他能在显示的行后附加多个和最后一行取值相同的行.

热心网友时间：2022-04-10 18:37

select * from record order by score desc limit 0,3

热心网友时间：2022-04-10 20:12

select * from record order by score where rownum <= 3

热心网友时间：2022-04-10 22:03

select top 3 name,score from record order by score(由低分到高分排列)
select top 3 name,score from record order by score desc(由高分到低分排列)

热心网友时间：2022-04-11 00:11

SQL中limit,rownum不能用
select top 3 * from record order by score desc

热心网友时间：2022-04-11 02:36

如果是MS SQL直接下Select Top 3 Score, name from record即可
Oracle比较复杂
select R, Name, Score from
(Select Rownum as R, name, Score from record order by Score)
where R<=3