DB2数据库，按照指定顺序排序

select * from (
SELECT distinct
               CASE ORG
               --先置别名
            WHEN 'AA' THEN 'BB'
            WHEN 'CC' THEN 'DD'
            WHEN 'EE' THEN 'HH'
            ELSE ORG
        END AS ORG
           FROM TABLEName)
           order by
           --使用decode函数进行排序
decode(ORG, 'DD' , 1,
'BB' , 2,
'HH' , 3))