mysql8 使用with as语法 ROW_NUMBER OVER

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;