-- 3、分组加序号
SELECT
ROW_NUMBER () OVER (
PARTITION BY a.remarks
ORDER BY
a.score DESC
) AS rowNum,
a.id,
a.score,
a.remarks
FROM
score a;
OW_NUMBER()
-- 3、分组加序号
SELECT
ROW_NUMBER () OVER (
PARTITION BY a.remarks
ORDER BY
a.score DESC
) AS rowNum,
a.id,
a.score,
a.remarks
FROM
score a;
OW_NUMBER()