SELECT SUM(CASE WHEN STATE=1 THEN 1 ELSE 0 END) ,SUM(CASE WHEN STATE=2 THEN 1 ELSE 0 END) ,SUM(CASE WHEN STATE=3 THEN 1 ELSE 0 END) ,SUM(CASE WHEN STATE=4 THEN 1 ELSE 0 END) FROM TB
--1 select (select count(1) from tb where State = 1) [1], (select count(1) from tb where State = 2) [2], (select count(1) from tb where State = 3) [3], (select count(1) from tb where State = 4) [4] --2 select sum(case State when 1 then 1 else 0 end) [1], sum(case State when 2 then 1 else 0 end) [2], sum(case State when 3 then 1 else 0 end) [3], sum(case State when 4 then 1 else 0 end) [4] from tb
select distinct state,count(1) over (partition by state) from tab
select distinct state,count(1) over (partition by state) from tab学习了!
,SUM(CASE WHEN STATE=2 THEN 1 ELSE 0 END)
,SUM(CASE WHEN STATE=3 THEN 1 ELSE 0 END)
,SUM(CASE WHEN STATE=4 THEN 1 ELSE 0 END)
FROM TB
select
(select count(1) from tb where State = 1) [1],
(select count(1) from tb where State = 2) [2],
(select count(1) from tb where State = 3) [3],
(select count(1) from tb where State = 4) [4]
--2
select
sum(case State when 1 then 1 else 0 end) [1],
sum(case State when 2 then 1 else 0 end) [2],
sum(case State when 3 then 1 else 0 end) [3],
sum(case State when 4 then 1 else 0 end) [4]
from tb
select distinct state,count(1) over (partition by state) from tab