查询分组统计

 

create table tb
(
id int,
名称 varchar(50),
分类 int,
编码 int,
用户ID int

)
 
insert into tb values(1,'A',1,1,1111)
insert into tb values(2,'B',1,0,3333)
insert into tb values(3,'C',2,0,3333)
insert into tb values(4,'D',3,0,3333)
insert into tb values(5,'E',3,0,4444)
insert into tb values(6,'F',3,0,4444)

 

 
 
SELECT 用户ID,

       sum(case when 分类 = 1 and 编码 = 0 then 1 else 0 end) [分类1编码0的数据],
       sum(case when 分类 = 1 and 编码 = 1 then 1 else 0 end) [分类1编码1的数据],
       sum(case when 分类 = 2 and 编码 = 0 then 1 else 0 end) [分类2编码0的数据],
       sum(case when 分类 = 2 and 编码 = 1 then 1 else 0 end) [分类2编码1的数据],
       sum(case when 分类 = 3 and 编码 = 0 then 1 else 0 end) [分类3编码0的数据],
       sum(case when 分类 = 3 and 编码 = 1 then 1 else 0 end) [分类3编码1的数据]
from tb
group by 用户ID

SELECT 用户ID,


from tb
group by 用户ID