Oracle 按指定顺序排序
select * from (select 'Nick' as item from dual union all select 'Viki' as item from dual union all select 'Glen' as item from dual union all select 'Robin' as item from dual union all select 'Total' as item from dual) pre_tab order by decode(item, 'Viki', 1, 'Glen', 2, 'Robin', 3, 'Nick', 4);