用以下类似的格式，自己嵌套下去吧select 经销商编码,"1月","2月" from(select 经销商编码,sum(销售额) as "1月" from 表 where 月份=1 ) aleft join (select 经销商编码,sum(销售额) as "2月" from 表 where 月份=2 ) bon a.经销商编码=b.经销商编码
