WITH T AS (
SELECT '비둘기' A, '10' B FROM DUAL
UNION ALL
SELECT '비둘기' A, '20' B FROM DUAL
UNION ALL
SELECT '비둘기' A, '30' B FROM DUAL
UNION ALL
SELECT '참새' A, '20' B FROM DUAL
UNION ALL
SELECT '참새' A, '30' B FROM DUAL
UNION ALL
SELECT '참새' A, '40' B FROM DUAL
)
SELECT a, max(b) FROM T
group by a
order by a
;
WITH t_a AS ( SELECT '사과' 이름, '과일' 소속, 2 수량 FROM dual UNION ALL SELECT '사과', '과일', 5 FROM dual UNION ALL SELECT '시금치', '야채', 3 FROM dual ) , t_b AS ( SELECT '사과' 이름, '오후2시' 팔린시간 FROM dual UNION ALL SELECT '시금치', '오전2시' FROM dual ) SELECT a.이름 , a.소속 , MAX(a.수량) 수량 , b.팔린시간 FROM t_a a , t_b b WHERE a.이름 = b.이름 GROUP BY a.이름, a.소속, b.팔린시간 ORDER BY b.팔린시간 ;
(
SELECT '사과' 이름, '과일' 소속, 2 수량 FROM dual
UNION ALL SELECT '사과', '과일', 5 FROM dual
UNION ALL SELECT '시금치', '야채', 3 FROM dual
)
, t_b AS
(
SELECT '사과' 이름, '오후2시' 팔린시간 FROM dual
UNION ALL SELECT '시금치', '오전2시' FROM dual
)
이부분에서 데이터를 직접 기입을 하는데, 데이터가 만건이 넘을 경우 다 입력하기엔 번거롭지않을까요??....
아닌가... 방법을 잘 모르겟습니다.ㅠ