Mysql Union实例
来源:互联网 发布:软件打不开是怎么了 编辑:程序博客网 时间:2024/06/05 18:48
前提,是每个查询结果集的列数要一样,类型要一样
SELECT g.goods_id FROM ( SELECT gr.`GOODS_ID`,COUNT(gr.`GOODS_ID`) num FROM rkgl_goods_repertory gr JOIN rkgl_repertory r ON r.`ID`=gr.`REPERTORY_ID` JOIN spgl_goods g ON g.`ID`=gr.`GOODS_ID` JOIN spgl_brand b ON b.`ID`=g.`BRAND_ID` JOIN spgl_goods_type gt ON gt.`ID`=g.`GOODS_TYPE_ID` WHERE r.`USER_ID`=36 AND g.`IS_DELETE`=FALSE AND gt.`IS_DELETE`=FALSE AND b.`IS_DELETE`=FALSE AND gr.`NUM`=0 GROUP BY gr.`GOODS_ID`) g WHERE g.num>1 UNION SELECT g.goods_id FROM ( SELECT gr.`GOODS_ID`,COUNT(gr.`GOODS_ID`) num FROM rkgl_goods_repertory gr JOIN rkgl_repertory r ON r.`ID`=gr.`REPERTORY_ID` JOIN spgl_goods g ON g.`ID`=gr.`GOODS_ID` JOIN spgl_brand b ON b.`ID`=g.`BRAND_ID` JOIN spgl_goods_type gt ON gt.`ID`=g.`GOODS_TYPE_ID` WHERE r.`USER_ID`=36 AND g.`IS_DELETE`=FALSE AND gt.`IS_DELETE`=FALSE AND b.`IS_DELETE`=FALSE AND gr.`NUM`=0 GROUP BY gr.`GOODS_ID`) g WHERE g.num=1
简单的实例就是
select * from a union select * from b
或者
(select * from a join b on a.id=b.a_id ) c union select * from d
还有一点就是UNION是过滤相同结果集求存不同结果集,而UNION ALL是全部累加一起。
0 0
- Mysql Union实例
- mysql中union、union all的用法实例
- mysql UNION UNION All
- mysql union ,UNION RESULT
- mysql union
- mysql union
- MySQL Union
- mysql union
- mysql union
- MySQL Union
- mysql--union
- mysql --- union
- mysql UNION 和 UNION ALL
- Mysql中UNION & UNION ALL
- mysql union all和union
- union使用实例
- C++ union 详解&实例
- union的实例
- Swift中文教程(三) 字符串和字符
- ThinkPHP的controller里变量输出位置不正确导致变量输出无效,原因不明??
- 掩模的概念
- 黑马程序员-IO(2)
- socket之select模型中各函数杂谈
- Mysql Union实例
- oracle空间数据库函数使用
- Activity基类广播退出APP
- 苹果Swift语言入门教程
- message type '' display like ''的意思
- onvif规范的实现:server端Discovery实现,通过OnvifTestTool12.06测试
- Instance渲染技术
- SVN提交被忽略的链接库文件(.a,.so)
- 无向图的深度优先遍历和广度优先遍历(邻接链表)