SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY groupByField ORDER BY orderByField DESC) rn FROM t1 ) t WHERE rn = 1