Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
UNION
On this page

UNION

Example

UNION ALL

UNION

The UNION operation combines the result sets of two or more SELECT statements. It returns a result set that contains all the unique rows from the combined sets.

The syntax to use UNION on the table is:

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;
Image

Example

Suppose we have two database tables with the names Customers and Suppliers as shown below

Image
Image

Now, we want to fetch the cities from the Customers and Suppliers tables. The query will go like this.

MYSQL
MYSQL
. . . .

And it will show the following result

Image

You may have noticed that even if duplicate cities exist, UNION listed each city only once because it selects distinct values.

UNION ALL

UNION ALL is similar to UNION but includes all rows from the combined sets, including duplicates.

The syntax to use UNION ALL is:

SELECT column_name(s) FROM table1
UNION ALL
SELECT column_name(s) FROM table2;

Using UNION ALL to query the same Customers and Suppliers table will provide the following results.

MYSQL
MYSQL
. . . .
Image

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page

UNION

Example

UNION ALL