sql统计,有时候 case when 比group by 好用
select
sum(case when to_char(cratedate,'yyyy')='2020' then 1 else 0) as nianfenzongshu
from k
sql统计,有时候 case when 比group by 好用
select
sum(case when to_char(cratedate,'yyyy')='2020' then 1 else 0) as nianfenzongshu
from k