oracel根据条件不同，统计数据sql

select count(case
               when ml_type = '00' then
                'gjml'
             end) gjml,
       count(case
               when ml_type = '32' then
                'jsml'
             end) jsml,
       count(case
               when use_level = '0' then
                'gjxs'
             end) gjxs,
       count(case
               when use_level = '01' then
                'sjxs'
             end) sjxs,
       count(case
               when use_level = '02' then
                'shijxs'
             end) shijxs,
       count(case
               when use_level = '03' then
                'xjxs'
             end) xjxs,
       count(case
               when use_level = '01,02,03' then
                'gtxs'
             end) gtxs
  from qzqd.T_CATALOG_MESSAGE t
 where 1 = 1
   and t.DATA_VALID_FLAG = '1'
   and STATE = '2'
   and YWTYPE != '3'

posted on 2021-09-13 17:23 IT-QI 阅读(36) 评论(0) 编辑收藏举报

oracel根据条件不同，统计数据sql

搜索

常用链接

随笔分类

随笔档案

阅读排行榜

评论排行榜

推荐排行榜

最新评论