| user_id | name | score |
| 1 | john | 1000 |
| 2 | mike | 1200 |
| 3 | jelly | 1300 |
| 4 | brook | 1500 |
| 5 | nanny | 1200 |
需要知道 user_id = k 的用戶對應(yīng)的積分排名
SELECT user_id, name, score, RANK() OVER (ORDER BY score DESC) FROM user;
| user_id | name | score | rank |
| 4 | brook | 1500 | 1 |
| 3 | jelly | 1200 | 2 |
| 2 | mike | 1300 | 3 |
| 5 | nanny | 1500 | 3 |
| 1 | john | 1200 | 5 |
如要獲取排名 3 的用戶：
SELECT user_id, name, score, user_rank FROM (SELECT user_id, name, score, RANK() OVER (ORDER BY score DESC) AS user_rank FROM user) AS T WHERE user_rank 3;
-- 注意子查詢在from中需要寫別名
| user_id | name | score | rank |
| 4 | brook | 1500 | 1 |
| 3 | jelly | 1200 | 2 |
以上為個人經(jīng)驗，希望能給大家一個參考，也希望大家多多支持腳本之家。如有錯誤或未考慮完全的地方，望不吝賜教。
