order by case when

最新推荐文章于 2022-09-12 13:49:30 发布

hybxiaodao

最新推荐文章于 2022-09-12 13:49:30 发布

阅读量111

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/hybxiaodao/article/details/84162204

版权

数据库专栏收录该内容

15 篇文章 0 订阅

订阅专栏

select * 
from view_bug_search view1 ,
        (select ROW_NUMBER() over(order by id desc ) as rownumber,id
         where 1=1 and 
                state in (1,2,3,4,5,6,9,12,14,15,16,18,19) and 
                (owner=88 or submitter=88 or itemcharger=88 or checkowner=88 or checkowner1=88 or checkowner2=88 or checkowner3=88 or testcharger=88 or belong=88 or belong1=88 or belong2=88 or belong3=88) ) row_view 
where view1.id=row_view.id and 
           row_view.rownumber between 1 and 20 
order by case 
                      when bugosstate=0 then 'severity desc' 
                      else 'thedate desc' 
               end

实现不同的 bugosstate = 0的时候按 severity 排序 bugosstate<>0的时候按thedate排序