SQL行转列

select  elmtName,measureName,
SUM(if(
crewName = "加热炉甲班",
consumption,0
)) as A1,
SUM(if(
crewName = "加热炉乙班",
consumption,0
)) as B1,
SUM(if(
crewName = "加热炉丙班",
consumption,0
)) as C1,
SUM(if(
crewName = "加热炉丁班",
consumption,0
)) as D1,
SUM(if(
crewName = "轧线甲班",
consumption,0
)) as A2,
SUM(if(
crewName = "轧线乙班",
consumption,0
)) as B2,
SUM(if(
crewName = "轧线丙班",
consumption,0
)) as C2,
SUM(if(
crewName = "轧线丁班",
consumption,0
)) as D2,

total from temp_crewcostcomparison order by type ASC;

结果呈现