Oracle 利用order by + case when 实现排序,置顶



1.先对表中创建人是'xinta' 的置顶,再根据TIMES_CITED 降序排序

select t.* from CUSTOM_LIST t order by case when t.creater='xinta' then 0 else 1 end,TIMES_CITED desc

2.先对表中创建人是'xinta' 的置顶,再将根据createOrg='001' 排在它的后面,再通过t.createOrg,t.createTime排序

select * from CustomList order by case when t.creater='xinta' then 0 when t.createOrg='001' then 1 else 2 end,t.createOrg,t.createTime