分享个分组排序的 SQL

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 2955 days ago, the information mentioned may be changed or developed.

查询返回每个 id 的前 5

SELECT yourtable.* FROM yourtable INNER JOIN ( SELECT id, GROUP_CONCAT(year ORDER BY rate DESC) grouped_year FROM yourtable GROUP BY id) group_max ON yourtable.id = group_max.id AND FIND_IN_SET(year, grouped_year) BETWEEN 1 AND 5 ORDER BY yourtable.id, yourtable.year DESC;

1 replies • 2018-03-29 19:29:27 +08:00

wqzjk393

Mar 29, 2018 via iPhone

没仔细看代码…但是分组排序不是有 row over partition 的么…