天天看點

oracle關于case when和count結合的用法

select count(case

when b.schedule = ‘0’ then

‘男’ else null end),

count(case when b.schedule = ‘1’ then

‘女’else null end)

from wsbs_apply b

繼續閱讀