Chinaunix首页 | 论坛 | 博客
  • 博客访问: 980920
  • 博文数量: 358
  • 博客积分: 8185
  • 博客等级: 中将
  • 技术积分: 3751
  • 用 户 组: 普通用户
  • 注册时间: 2008-10-15 16:27
个人简介

The views and opinions expressed all for my own,only for study and test, not reflect the views of Any Company and its affiliates.

文章分类

全部博文(358)

文章存档

2012年(8)

2011年(18)

2010年(50)

2009年(218)

2008年(64)

我的朋友

分类: Oracle

2009-07-06 23:13:28

■ UNION Returns the combined rows from two queries, sorting them and removing duplicates.
■ UNION ALL Returns the combined rows from two queries without sorting or removing duplicates.
■ INTERSECT Returns only the rows that occur in both queries’ result sets,sorting them and removing duplicates.
■ MINUS Returns only the rows in the first result set that do not appear in the second result set, sorting them and removing duplicates.


The only place where an ORDER BY clause is permitted is at the end of the compound query.only once;
阅读(1209) | 评论(0) | 转发(0) |
0

上一篇:Subqueries

下一篇:Manipulating Data

给主人留下些什么吧!~~