japinli's recent timeline updates japinli's recent timeline updates |
japinliV2EX member #416598, joined on 2019-05-29 17:03:29 +08:00 |
japinli's recent replies
May 29, 2019 Replied to a topic by imherer › PostgreSQL › 如下表结构如何效率的获得自己的排名? |
用窗口函数可以不行吗？
SELECT id, score, RANK() OVER (ORDER BY score) FROM table_name LIMIT 10 OFFSET 10;
SELECT id, score, RANK() OVER (ORDER BY score) FROM table_name LIMIT 10 OFFSET 10;
Select Language