SELECT * FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY groupByField ORDER BY orderByField DESC) rn FROM t1
) t WHERE rn = 1
转载于:https://www.cnblogs.com/laop/p/10400726.html
SELECT * FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY groupByField ORDER BY orderByField DESC) rn FROM t1
) t WHERE rn = 1
转载于:https://www.cnblogs.com/laop/p/10400726.html