SELECT *
FROM (SELECT T.*,
ROW_NUMBER() OVER(PARTITION BY T.AREA_CODE ORDER BY ROWNUM) CN
FROM TT_AREA T)
WHERE CN = 1;
SELECT *
FROM (SELECT T.*,
ROW_NUMBER() OVER(PARTITION BY T.AREA_CODE ORDER BY ROWNUM) CN
FROM TT_AREA T)
WHERE CN = 1;