SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY x ORDER BY y DESC) rn,test1.* FROM test1) WHERE rn = 1 ;
posted on 2016-09-22 11:30 马文柱 阅读(266) 评论(0) 编辑 收藏 举报