PDQ.com mobilePDQ.com desktop
Support

SQL UNION vs UNION ALL

Stephanie WarnerStephanie Warner
·

UNION

UNION is one of the four basic ‘set operators’ in SQL.  The UNION operator is used to combine the results of two or more SELECT Statement queries into a single result-set, excluding duplicate values. Using the UNION operator will not allow duplicate values in the results. (See UNION ALL for results allowing duplicate values.) There are specific protocols to follow when using UNION in a query:

  1. Each SELECT statement used with the UNION operator must have the same exact number of columns.

  2. The fields used in the SELECT statements must be in the same order as one another.

  3. The fields used in each SELECT statement must have corresponding data types, meaning they must be alike.

Syntax Example

SELECT column_1, column_2, column_N
FROM table_A
UNION
SELECT column_1, column_2, column_N
FROM table_B;

NOTE: ‘column_1’ in each SELECT statement MUST be similar data types, ‘column_2’ in each SELECT statement must also be of similar data types, etc.

UNION ALL

UNION ALL is also a ‘set operator’ in SQL Server. The UNION ALL operator performs -in a similar way to the UNION operator, in the sense that it too combines the result sets of two or more SELECT statements. The difference lies within the results; UNION ALL allows duplicate records in the results as UNION does not.

Syntax Example

SELECT column_1, column_2, column_N
FROM table_A
UNION ALL
SELECT column_1, column_2, column_N
FROM table_B;

This blog post is part of our SQL series:

SQL Set Operators

SQL JOINS

SQL INNER JOIN

SQL LEFT JOIN

SQL Right Join

SQL Full Outer Join

Ready to get started?

Take our 14-day Free Trial.
This round is on us!

Don't miss the next post!

Using PowerShell to Install Printers

When installing printers, we will need to do the four things; Add Driver to the Store, Install the Driver, Create Printer Port, and Install the Printer