oracel 数据库按已知数据的id排序,把已知数据放在最前面

select *
  from fai_technician
 order by case
            when id = '201705270915260005010327152301984dbd80b8' then
             0
            else
             1
          end asc,
          id asc

 

posted @ 2017-07-21 15:43  赤子之心_timefast  阅读(274)  评论(0编辑  收藏  举报