一个sql查询数据问题，朋友进来看看，谢谢大家！

[jueyingfd]

[jaydom]

我的朋友，我的家。。。。。

[百年树人]

select 
  taskid,
  sum(case when step='开始' then 1 else 0 end) as 开始,
  sum(case when step='主管审批' then 1 else 0 end) as 主管审批,
  sum(case when step='总经理审批' then 1 else 0 end) as 总经理审批
from
  tb
group by 
  taskid

[hao1hao2hao3]

select taskid,sum(case when step ='开始' then date else 0 end) as '开始',
			  sum(case when step ='主管审批' then date else 0 end) as '主管审批',
			  sum(case when step ='总经理审批' then date else 0 end) as '总经理审批'
from tb
group by taskid

[百年树人]

[Quote=引用 1 楼 josy 的回复:]
SQL code
select
taskid,
sum(case when step='开始' then 1 else 0 end) as 开始,
sum(case when step='主管审批' then 1 else 0 end) as 主管审批,
sum(case when step='总经理审批' then 1 else 0 end) as 总经理审批
fr……
[/Quote]

select 
  taskid,
  sum(case when step='开始' then [date] else 0 end) as 开始,
  sum(case when step='主管审批' then [date] else 0 end) as 主管审批,
  sum(case when step='总经理审批' then [date] else 0 end) as 总经理审批
from
  tb
group by 
  taskid

[jueyingfd]

再此非常感谢一楼和四楼的朋友，虽然四楼也写的对，但是您不是第一个写出来的，所以给您的分数比一楼少点，希望不要见怪，再次感谢