被迫排序

最新推荐文章于 2021-11-20 10:48:06 发布

Peas4

最新推荐文章于 2021-11-20 10:48:06 发布

阅读量164

点赞数

分类专栏： Oracle知识文章标签：排序

本文链接：https://blog.csdn.net/Tomcat_19890903/article/details/84618360

版权

Oracle知识专栏收录该内容

18 篇文章 0 订阅

订阅专栏

select DISTINCT c.ITEM_NUM,i.WAGE_ITEM from urp_wage.T_WAGE_TXGZ_ITEM c
     inner join urp_wage.t_wage_item I on C.ITEM_NUM = I.ITEM_NUM order by
     case when item_num='0001' then 1 when item_num='0002' then 2
      when item_num='0029' then 3 when item_num='0025' then 4
         when item_num='0030' then 5 when item_num='0027' then 6
            when item_num='0003' then 7 when item_num='0031' then 8
               when item_num='0022' then 9 when item_num='0028' then 10
                  when item_num='0020' then 11 when item_num='0032' then 12
                     when item_num='0033' then 13 when item_num='0021' then 15
                        when item_num='0034' then 15
     end