Question

sql中把查询结果从竖列转为横向

我自己写了一个，但是结果发生错行了，求指点 select 名称, (case when 目标='财务' then 完成日期 end) as 财务,(case when 目标='技术' then 完成日期 end) as 技术,(case when 目标='设计' then 完成日期 end) as 设计,(case when 目标='行政' then 完成日期 end) as 行政from table1 left join table2 on table2.yb=table1.id

Answer 1

select a as A,max(case when b='a' then c end) as a,max(case when b='b' then c end) as b,max(case when b='c' then c end) as c,max(case when b='d' then c end) as d from a

追问

给的这是什么鬼