SELECT
T1.*
FROM
(
SELECT
ROW_NUMBER () OVER ( PARTITION BY T.A1 ORDER BY T.A2 DESC ) rn,
T.*
FROM TEST T
) T1
WHERE T1.rn =1
SELECT
T1.*
FROM
(
SELECT
ROW_NUMBER () OVER ( PARTITION BY T.A1 ORDER BY T.A2 DESC ) rn,
T.*
FROM TEST T
) T1
WHERE T1.rn =1