立即与支持人员聊天
与支持团队交流

Toad for DB2 7.4 - Installation Guide

Add Union Operators

A Union operator joins the results of rows from two or more SELECT statements. Any statement combined with a Union operator must have the same number of columns, and those columns must have the same data type and length. The following operators are available:

  • Union—Returns all rows found in any queried table, but removes any duplicate rows.
  • Union All—Returns all rows found in any queried table, including any duplicate rows.
  • Intersect—Returns only those rows that are in both queried tables that do not have duplicate rows.
  • Intersect All—Returns all rows that are in both queried tables, including any duplicate rows.
  • Except—Returns all rows found in the first queried table that do not display in the second queried table.
  • Except All—Returns all rows found in the second queried table that do not display in the second queried table.

Notes: 

  • This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To add a union operator

  1. Select tables or views in the Query Builder and create a query.

  2. Click the arrow beside the Union operator on the toolbar and select an operator:


  

Related Topics

Build Queries Visually

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级