急！用透视表做成附件中的样式

crmserver

需要根据上面的表，用透视表做成下面的样式，请看附件

crmserver

版主，专家们帮忙啊！

wuxiang_123

1. sql参考:
   
2. SELECT 地区,审计,优良,数,审核,结果,"结果" AS 分类 FROM
   
3. (SELECT *,"A审计结果" AS 结果 FROM
   
4. (select count(优良) as 数,地区,审计,优良,审核 FROM
   
5. (select 地区,"第一次审计时间" AS 审计,A审计结果 AS 优良,FORMAT(第一次审计时间,"YYYY-MM") AS 审核 FROM [sheet1$a1:j5]
   
6. UNION ALL
   
7. select 地区,"第二次审计时间",A审计结果1,FORMAT(第二次审计时间,"YYYY-MM") FROM [sheet1$a1:j5]
   
8. union all
   
9. select 地区,"第三次审计时间",A审计结果2,FORMAT(第三次审计时间,"YYYY-MM") FROM [sheet1$a1:j5])
   
10. GROUP BY 地区,审计,优良,审核)
    
11. UNION ALL
    
12. SELECT *,"B审计结果" FROM
    
13. (select count(优良) as 数,地区,审计,优良,审核 FROM
    
14. (select 地区,"第一次审计时间" AS 审计,B审计结果 AS 优良,FORMAT(第一次审计时间,"YYYY-MM") AS 审核 FROM [sheet1$a1:j5] UNION ALL
    
15. select 地区,"第二次审计时间",B审计结果1,FORMAT(第二次审计时间,"YYYY-MM") FROM [sheet1$a1:j5] union all
    
16. select 地区,"第三次审计时间",B审计结果2,FORMAT(第三次审计时间,"YYYY-MM") FROM [sheet1$a1:j5] )
    
17. GROUP BY 地区,审计,优良,审核))
    
18. union all
    
19. SElECT 地区,审计,"",数,审核,"","数量" FROM
    
20. (select 地区,审计,count(审计) as 数,审核 FROM
    
21. (select 地区,"第一次审计时间" AS 审计,FORMAT(第一次审计时间,"YYYY-MM") AS 审核 FROM [sheet1$a1:j5]
    
22. UNION ALL
    
23. select 地区,"第二次审计时间",FORMAT(第二次审计时间,"YYYY-MM") FROM [sheet1$a1:j5]
    
24. union all
    
25. select 地区,"第三次审计时间",FORMAT(第三次审计时间,"YYYY-MM") FROM [sheet1$a1:j5])
    
26. GROUP BY 地区,审计,审核)

复制代码

这样应该更准确.

[ 本帖最后由 wuxiang_123 于 2010-3-6 12:02 编辑 ]

crmserver

谢谢啦！！！！！！！

heshl2001

这么复杂的查询语句,得好好学习了!

条形码

哇噻，这么长的语句得好好学学，先作个标记。