展开全部
可以用row_number来查询。
1、创建数据表,插入数据:create table sc
(id int,
name varchar(20),
class varchar(20),
score int);
insert into sc values (1,'badkano','一年一班62616964757a686964616fe59b9ee7ad9431333337616461',100);
insert into sc values (2,'百度知道团长','一年一班',99);
insert into sc values (3,'du小短','一年一班',95);
insert into sc values (4,'du小小动','一年一班',97);
insert into sc values (5,'du小智','一年一班',80);
insert into sc values (6,'吕布','一年二班',67);
insert into sc values (7,'赵云','一年二班',90);
insert into sc values (8,'典韦','一年二班',89);
insert into sc values (9,'关羽','一年二班',70);
insert into sc values (10,'马超','一年二班',98);
commit;
2、查询分数的前三名,可用以下语句:select * from
(select row_number() over (order by score desc) rn,sc.* from sc)
where rn<=3;
3、结果显示: