SELECT b.*
FROM ( SELECT a.* ,
ROW_NUMBER() OVER ( PARTITION BY 列1 ORDER BY 列2 DESC ) rn
FROM a
) b
WHERE rn = 1;
SQL获取每组中的第一条数据
最新推荐文章于 2024-04-24 13:27:31 发布
SELECT b.*
FROM ( SELECT a.* ,
ROW_NUMBER() OVER ( PARTITION BY 列1 ORDER BY 列2 DESC ) rn
FROM a
) b
WHERE rn = 1;