空地

摘要：use db_student select * from sp pivot(sum(销售数量) for 商品名称 in ([李专辑],[张专辑]))) as 统计 select 商品名称,a.[9] as [九月],a.[10] as [十月],a.[11] as [十一月],a.[12] as [十二月] from sp pivot(sum(销售数量) for 月份 in([9],[10],[... 阅读全文