经典的SQL行列转换

select hyid,max(case mdid when 6 then je else 0 end) 春熙店,
max(case mdid when 7 then je else 0 end) 全兴店,
max(case mdid when 15 then je else 0 end) 天府店,
max(case mdid when 8 then je else 0 end) 新馆店

 from (
select mdid,hyid,sum(je) as je  from hyxfjl where to_char(xfsj,'yyyymmdd') between 20111203 and 20111218 group by mdid,hyid)
group by hyid 

转载于:https://www.cnblogs.com/luqingsong/archive/2011/12/22/2297554.html