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
oracle关于case when和count结合的用法
最新推荐文章于 2024-04-17 11:47:44 发布
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