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
查询分组统计
最新推荐文章于 2023-12-28 09:19:02 发布