easy 假设表 a classid班级 s_id学号 score成绩select a.*,row_number() over(partition by classid order by score desc) rn from a order by row_number() over(partition by classid order by score desc)
使用下面语句, select b....., ceil(b.rn/4) as 名次 from ( select a.*,row_number() over(partition by classid order by score desc) rn from a order by row_number() over(partition by classid order by score desc)) B不好意思,借用楼上的部分语句。
假设表 a
classid班级 s_id学号 score成绩select a.*,row_number() over(partition by classid order by score desc) rn
from a
order by row_number() over(partition by classid order by score desc)
select b.....,
ceil(b.rn/4) as 名次
from (
select a.*,row_number() over(partition by classid order by score desc) rn
from a
order by row_number() over(partition by classid order by score desc)) B不好意思,借用楼上的部分语句。