with t as (
select '미국' no, 21 name from dual
union all select '캐나다', 22 from dual
union all select '한국', 23 from dual
)
select t1.no, t2.name from t t1 left outer join t t2 on t1.no = t2.no and t1.name > 30;
by 마농
[2020.10.20 16:21:31]
WITH t AS
(
SELECT '미국' no, 21 name FROM dual
UNION ALL SELECT '캐나다', 22 FROM dual
UNION ALL SELECT '한국' , 23 FROM dual
)
SELECT no
, CASE WHEN name > 30 THEN name END name
FROM t
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.