Oracle-- (RANK) 排名函数
rank() over (order by 字段 顺序)
查询人员,成绩,排名
select
a.name AS "name",
a.score AS "score",
rank() over(order by a.score desc) AS "rank"
from
study a
select
a.name AS "name",
a.score AS "score",
rank() over(order by a.score desc) AS "rank"
from
study a