DataBase

[오라클] DECODE 를 [MSSQL] CASE 문으로 바꾸기

jason.moon 2011. 6. 23. 15:05
[오라클]
DECODE(GROUPING(rnum), 1, 'D000', MAX(BIZ_PLC_ID)) AS "BIZPLCID",

[MSSQL]
CASE GROUPING(rnum) WHEN 1 THEN 'D000' ELSE MAX(BIZ_PLC_ID) END "BIZPLCID",