首页 > 技术文章 > oracle分组取第一条
mawenzhu 2016-09-22 11:30 原文
SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY x ORDER BY y DESC) rn,test1.* FROM test1) WHERE rn = 1 ;