多条数据合并 表 字段 ID fee type 1 20 1 1 30 1 1 40 2需要得到输出是:ID fee1 fee21 50 40 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT ID,SUM(CASE WHEN TYPE=1 THEN FEE ELSE 0 END)AS FEE1,SUM(CASE WHEN TYPE=2 THEN FEE ELSE 0 END)AS FEE2FROM TB GROUP BY ID select id, sum(case when type=1 then fee else 0 end) as fee1, sum(case when type=2 then fee else 0 end) as fee2from 表group by id select id, sum(case type when 1 then fee else 0 end) as 'fee1', sum(case type when 2 then fee else 0 end) as 'fee2'from tbgroup by id select ID, sum(case when type=1 then fee else 0 end) as fee1,sum(case when type=2 then fee else 0 end) as fee2 from TAB group by ID CREATE UNIQUE INDEX 终止,因为发现了索引 ID 1 的重复键。最重要的主键为 '001304'。 一个SQL题目不会啊!急急急。 如下,偶建立了一个函数,但是无法执行,请教各位老大,如何解决 SQL数据插入的类型是?我只想精确 1.725 就是1.725 ,0.625就是0.625 可以将SQL数据库以单个文件的形式操作吗? IP段的查询!在线! 向大家请教一个SQL问题。谢谢!谢谢! 请教sql语句的二次运算问题~ 怎样设置报表变量???急急急!!!在线等待 请教各路高手: 存储过程中使用exec执行sql 含有时间字段的Select语句根据Code提取最大时间的记录?
SUM(CASE WHEN TYPE=1 THEN FEE ELSE 0 END)AS FEE1,
SUM(CASE WHEN TYPE=2 THEN FEE ELSE 0 END)AS FEE2
FROM TB GROUP BY ID
id,
sum(case when type=1 then fee else 0 end) as fee1,
sum(case when type=2 then fee else 0 end) as fee2
from
表
group by
id
id,
sum(case type when 1 then fee else 0 end) as 'fee1',
sum(case type when 2 then fee else 0 end) as 'fee2'
from
tb
group by
id