개발/DB(Oracle, MySQL)
where 절 case then
쵸코푸들이장군
2018. 2. 11. 09:04
and
(
case when A.ACT_YEAR is not null
then to_char(a.ACT_YEAR)
else to_char(a.START_DTM,'YYYY') end
) = '2012'