SQL嵌套查询总结 潇湘博客
来源:互联网 发布:宏观经济数据公布时间 编辑:程序博客网 时间:2024/04/30 02:07
IT也有一段时间了,刚开始的时候``````
的困难主要是在编程语言上,数组,逻辑,算法,...
这些都过来了之后,困难就上升到数据库设计上了.
以及数据逻辑.
一个优秀的系统,会集成优秀的程序和优秀的数据库设计.
要做到这点得有足够的经验.
这是我写的一个结合UINON的嵌套查询.
将五个方面的报表放到一个临时表里,再从临时表里,将
所要的数据查询出来.
$sql="SELECT type , sum( yjsl ) as yjsl , sum( yysl ) as yysl, sum( jyrs ) as jyrs, sum( jycs ) as jycs
FROM (
SELECT c.mc AS
TYPE , count( d.lsh ) AS yjsl, 0 AS yysl, 0 AS jyrs, 0 AS jycs
FROM sys_dzxxb AS b, sys_jcb AS c, sys_dzyjb AS d
WHERE b.bm = c.lsh
AND d.dzlsh = b.lsh
GROUP BY c.mc
UNION SELECT c.mc AS
TYPE , 0 AS yjsl, count( e.lsh ) AS yysl, 0 AS jyrs, 0 AS jycs
FROM sys_dzxxb AS b, sys_jcb AS c, sys_dzyy AS e
WHERE b.bm = c.lsh
AND e.dzlsh = b.lsh
GROUP BY c.mc
UNION SELECT c.mc AS
TYPE , 0 AS yjsl, 0 AS yysl, count( DISTINCT e.dzlsh ) AS jyrs, 0 AS jycs
FROM sys_dzxxb AS b, sys_jcb AS c, sys_ltxxb AS e
WHERE b.bm = c.lsh
AND e.dzlsh = b.lsh
GROUP BY c.mc
UNION SELECT c.mc AS
TYPE , 0 AS yjsl, 0 AS yysl, 0 AS jyrs, count( DISTINCT e.lsh ) AS jycs
FROM sys_dzxxb AS b, sys_jcb AS c, sys_ltxxb AS e
WHERE b.bm = c.lsh
AND e.dzlsh = b.lsh
GROUP BY c.mc
) AS temptable
GROUP BY TYPE ";
分享给大家.
- SQL嵌套查询总结 潇湘博客
- mysql limit查询优化 潇湘博客
- css 通配符用法总结 潇湘博客
- 6条策略提高mysql查询速度 潇湘博客
- 使用Limit参数优化MySQL查询 潇湘博客
- 博客工具 潇湘博客
- mysqldump命令 潇湘博客
- jquery tab 潇湘博客
- js 格式化 潇湘博客
- ini_set 潇湘博客
- 潇湘博客 有GOOGLEPR值了 潇湘
- sql嵌套子查询
- SQL 嵌套多层查询
- sql嵌套查询
- SQL嵌套子查询
- SQL嵌套查询
- SQL嵌套子查询
- SQL嵌套查询
- 帮帮忙 ,vc++6.0引用控件的一个问题,急!!!!
- 类的成员初始化顺序
- Reporting Service 设置中文Bar
- MSMQ的简单包装类
- 我的研究体验--转浙大杨骏的研究心得(比较实在的)
- SQL嵌套查询总结 潇湘博客
- 详细说明mantis在windowsXP下的安装过程(IIS+MYSQL+PHP)
- 企业网站营销策划-第二步网站推广
- 网站推广方式大收集
- 践踏
- 不同数据库取前几个字段的方法
- 一个mm和各路神仙的对话
- oracle的字符集:WE8ISO8859P1 , ZHS16GBK
- junit4-加载顺序测试