See following SQL
SELECT DISTINCT c1 FROM t1
UNION
SELECT c1 FROM t2
@
We could remove DISTINCT safely. UNION will do what DISTINCT does here. See following sample.
SELECT c1 FROM t1@
c1
----
1
1
2
SELECT c1 FROM t2@
c1
----
2
3
3
SELECT c1 FROM t1
UNION
SELECT c1 FROM t2
@
c1
----
1
2
3
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2006-04-07 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Development (24)
