交叉表 查询 例子(Sql Server 2005)
摘要：
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],[... 阅读全文
posted @ 2008-02-02 20:52 小梅 阅读(1217) 评论(0) 推荐(0) 编辑