mysql四大排序函数

create table scores2021-08-24
(   id int(6)
   ,score DOUBLE(4,2)
);
insert into scores values(1,3.50);
insert into scores values(2,3.65);
insert into scores values(3,4.00);
insert into scores values(4,3.85);
insert into scores values(5,4.00);
insert into scores values(6,3.65);
commit;
select
    id 
   ,score
   ,rank() over(order by score desc) `rank`               #按照成绩排名，纯排名
   ,dense_rank() over(order by score desc) `dense_rank`   #按照成绩排名，相同成绩排名一致
   ,row_number() over(order by score desc) `row_number`   #按照成绩依次排名
   ,ntile(3) over (order by score desc) `ntile`           #按照分数划分成绩梯队
from scores;