Sunday, 1 December 2024

Oracle SQL加入指定順序排序

Oracle SQL加入指定順序排序

於Order by 搭配Decode擷取關鍵字進行排序

例如:


ORDER BY CLS_TYP_CD, DECODE(CLS_LVL_CD,'F',1, 'T',2, 'A',3,'Z',4 ), SUB_CLS_LVL_CD

No comments:

Post a Comment

IIS HTTP Error 403.18

 HTTP Error 403.18 - Forbidden The specified request cannot be processed in the application pool that is configured for this resource on the...