这个思路的sql如何写
SQL code
select ( select COUNT(*) from tmp where tmp.f1=v1),
( select COUNT(*) from tmp where tmp.f2=v2),
( select COUNT(*) from tmp where tmp.f3=v3),
...
from (select * from table1 where f0 =...) as tmp
???
------解决方案--------------------
select case when tmp.f1=v1 then .....else 0 end as ...,
case when 实现
------解决方案--------------------
select
sum(case when f0 = ... and f1 = 'v1' then 1 else 0 end) ,
sum(case when f0 = ... and f2 = 'v2' then 1 else 0 end) ,
sum(case when f0 = ... and f3 = 'v3' then 1 else 0 end) ,
...
from table1