그룹별 최고값 가져오기 - GROUP BY MAX

#테이블

f1	f2	f3
aaa	...	1,000
aaa	...	1,100
bbb	...	1,500

#쿼리

SELECT f1, f2, f3

FROM (

SELECT f1, f2, f3

, ROW_NUMBER() OVER(PARTITION BY f1 ORDER BY f3 DESC) as RowIdx

FROM tb_User

) AS t1

WHERE RowIdx = 1

#결과

f1	f2	f3
aaa	...	1,100
bbb	...	1,500