WITH T1 AS (
SELECT '0810' AS TRAN_TIME, 'A' AS NNAME, 150 AS QTY, 10 AS HIST_ORDER FROM DUAL UNION ALL
SELECT '0830', 'A', 140, 16 FROM DUAL UNION ALL
SELECT '0910', 'B', 110, 12 FROM DUAL UNION ALL
SELECT '0920', 'B', 130, 14 FROM DUAL UNION ALL
SELECT '0930', 'B', 120, 18 FROM DUAL
)
SELECT *
FROM T1
결과
0830, A, 140, 16
0930, B, 120, 18
NNAME을 키로 중복 제거 해야하는데요,
조건은 HIST_ORDER가 큰것의
TRAN_TIME, NNAME, QTY, HIST_ORDER 를 가져오면 되는데 방법이 있을까요? |