Javatpoint Logo
Javatpoint Logo

SQL Server UNION Operator

In SQL Server, the UNION operator is used to combine the result-set of two or more SELECT statements.

Syntax:

Parameter explanation

expression1, expression2, ... expression_n: expressions specify the columns or calculations that you want to compare between the two SELECT statements.

tables: It specifies the tables that you want to retrieve records from. There must be at least one table listed in the FROM clause.

WHERE conditions: It is optional condition. It specifies the conditions that must be met for the records to be selected.

Image representation:

SQL union operator 1

Note: The covered blue area specifies the union data.


UNION operator with single expression

Example:

Output:

SQL union operator 2

UNION operator with multiple expressions

Example:

Let's use multiple expressions of each table. For example: id, name, salary.

Output:

SQL union operator 3

UNION ALL Operator

The UNION operator selects only distinct values by default. So, the UNION ALL operator is used to allow duplicate values also.

Example:

Output:

SQL union operator 4




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA