oracle case when的用法

最新推荐文章于 2022-02-21 17:01:10 发布

ghvbngf

最新推荐文章于 2022-02-21 17:01:10 发布

阅读量715

点赞数

分类专栏： ORACLE

本文链接：https://blog.csdn.net/ghvbngf/article/details/22798077

版权

ORACLE 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

select distinct(lot_code) lotcode,count(distinct(issue_id)) issuecount,
       sum(case when total_amount = total_amount then total_amount else 0 end) sellcount,
       sum(case when handle_status=300 and cancel_status=0 then total_amount else 0 end) ycpje,
       sum(case when handle_status>=0 and handle_status<300 and cancel_status=0 then total_amount else 0 end) dcpje,
       sum(case when cancel_status=200 then total_amount else 0 end) cpscdje,
       sum(case when cancel_status=900 then total_amount else 0 end) xtcdje
       from bet_project where 1=1 and storage_time>=to_date('20130402','yyyyMMdd') and storage_time<to_date('20140402','yyyyMMdd') group by lot_code

case when （条件表达式） then （条件表达式为真的时候执行then里面的语句块） else （反之，执行else里面的语句块） end

case when 语句适应于单表多条件查询