oracle分组取第一条

SELECT *  FROM (SELECT ROW_NUMBER() OVER(PARTITION BY x ORDER BY y DESC) rn,test1.* FROM test1)  WHERE rn = 1  ;     
原文地址:https://www.cnblogs.com/mawenzhu/p/5895628.html