and
(
case when A.ACT_YEAR is not null
then to_char(a.ACT_YEAR)
else to_char(a.START_DTM,'YYYY') end
) = '2012'
'개발 > DB(Oracle, MySQL)' 카테고리의 다른 글
| merge into on (0) | 2018.02.11 |
|---|---|
| 날짜비교 Between (0) | 2018.02.11 |
| 이것저것 (0) | 2018.02.11 |
| DB IMPORT (0) | 2018.02.11 |
| group by (0) | 2018.02.11 |