`

被迫排序

阅读更多

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

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics