WITH T AS (
SELECT id, name, ROW_NUMBER () OVER (PARTITION BY name ORDER BY name ASC) AS rn FROM table1
)
SELECT * FROM T
WHERE T.rn < 3
GROUP BY T.id, T.name;
mysql8 使用with as语法 ROW_NUMBER OVER
最新推荐文章于 2024-04-25 15:31:43 发布
WITH T AS (
SELECT id, name, ROW_NUMBER () OVER (PARTITION BY name ORDER BY name ASC) AS rn FROM table1
)
SELECT * FROM T
WHERE T.rn < 3
GROUP BY T.id, T.name;