Oracle中order by case 用法

select *
        from ly_familyinformation
       where  iszfbtperson = '0'
       and file_id='105047013002523'
       order by case
                  when relation = '购房人/申请人' then
                   0
                  when relation = '配偶' then
                   1
                  else
                   2
                end,
                applyer;

 1.随他大小便把

2.蹭着月色撩人，我们、、、、

3.小燕携泥一样，一点点把家置办成这样

4.如今铁窗泪呀

5.跟你妈说话像吃了蜜似的，怎么跟我说话就跟吃了屎似的

转载于:https://www.cnblogs.com/wangjp-1233/p/10548999.html