web | Java

写出SQL按照分数从高到低排序

千锋教育

select id,score,rank() over(order by score desc) `排名` from scores