Oracle 按照指定顺序排列方法

 

select t.*from tb_user t

 

--排序顺序by id 3 1 4 2 5
select id, name
  from tb_user
 where id in ('1', '2', '3', '4','5')
 order by (case id
            when '3' then
             'A'
            when '1' then
             'B'
            when '4' then
             'C'
            when '2' then
             'D'
              when '5' then
             'E'
          end)