本文提供了一个SQL查询案例，展示了如何从lcm_application表中按类型和日期筛选并聚合数据，最终通过PIVOT操作将结果转置以方便展示。
select * from (
select type,count(1) count, statdate from lcm_application where statdate like '2011%' group by statdate,type
) a pivot ( sum(count) for type in ([环境申请单],[设备申请单]) ) as b
select type,count(1) count, statdate from lcm_application where statdate like '2011%' group by statdate,type
) a pivot ( sum(count) for type in ([环境申请单],[设备申请单]) ) as b
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
