初始表字段及数据
查询语句
with stu as(
select *,row_number() over(order by score desc ) level from student)
select * from stu where level>=5 and level<=10;
查询结果
初始表字段及数据
查询语句
with stu as(
select *,row_number() over(order by score desc ) level from student)
select * from stu where level>=5 and level<=10;
查询结果