更新时间:2022-06-30 05:52:11
select
score,
(
select count(score) + 1 from score s2
where s2.score > s.score
) ranking
from score s order by score desc;
select
score,
(
select count(distinct score) from score s2
where s2.score >= s.score
) ranking
from score s order by score desc;
select
score,
course_id,
(
select count(score) + 1 from score s2
where s2.course_id = s.course_id and s2.score > s.score
) ranking
from score s
order by course_id,score desc;
select
score,
course_id,
(
select count(distinct score) from score s2
where s2.course_id = s.course_id and s2.score >= s.score
) ranking
from score s
order by course_id,score desc;