데이터베이스 질문과 답변
A칼럼 B칼럼 C칼럼 D칼럼
1 A 20118112 001 TT
2 A 20118112 002 YY
3 A 20118114 003 HH
4 B 20118112 001 UU
5 B 20118112 002 KK
결과---------------------------------------------------------------------
A 20118114 003 HH
B 20118112 002 KK
by 우리집아찌
[2019.01.07 10:23:59]
WITH T ( A, B, C ,D ) AS (
SELECT 'A' , '20118112' , '001' , 'TT' FROM DUAL UNION ALL
SELECT 'A' , '20118112' , '002' , 'YY' FROM DUAL UNION ALL
SELECT 'A' , '20118114' , '003' , 'HH' FROM DUAL UNION ALL
SELECT 'B' , '20118112' , '001' , 'UU' FROM DUAL UNION ALL
SELECT 'B' , '20118112' , '002' , 'KK' FROM DUAL
)
SELECT A , B , C , D
FROM (SELECT A , B , C , D
, ROW_NUMBER() OVER(PARTITION BY A ORDER BY B DESC , C DESC ) RN
FROM T
)
WHERE RN = 1
) 버튼을 클릭하여 작성 하시면 됩니다.