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
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