Oarcle 字段分组Count

COUNT(s.apply_id) QUITCOUNT,
count(case when T.CL_FLAG=1 then 1 else null end ) JQUITCOUNT,
count(case WHEN T.CL_FLAG=0 then 1 else null end ) FQUITCOUNT

posted on 2016-09-19 17:32  ningmou  阅读(156)  评论(0)    收藏  举报