Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL UNION ALL Keyword

Concept visual

SQL UNION ALL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

UNION ALL Keyword

Union All

The UNION ALL

command combines the result set of two or more SELECT statements (allows duplicate values).

The following SQL statement returns the cities

(duplicate values also) from both the "Customers" and the "Suppliers" table:

Example

SELECT City FROM Customers

Union All

SELECT City FROM Suppliers

ORDER BY City;

SQL UNION ALL Keyword

Concept visual

SQL UNION ALL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

UNION ALL Keyword

Union All

The UNION ALL

command combines the result set of two or more SELECT statements (allows duplicate values).

The following SQL statement returns the cities

(duplicate values also) from both the "Customers" and the "Suppliers" table:

Example

SELECT City FROM Customers

Union All

SELECT City FROM Suppliers

ORDER BY City;

SQL UNION ALL Keyword

SQL UNION ALL Keyword

UNION ALL Keyword

Previous

Next

Union All

The UNION ALL

The following SQL statement returns the cities

Example

SELECT City FROM Customers

Union All

SELECT City FROM Suppliers

Previous

Next

SQL UNION ALL Keyword

SQL UNION ALL Keyword

UNION ALL Keyword

Previous

Next

Union All

The UNION ALL

The following SQL statement returns the cities

Example

SELECT City FROM Customers

Union All

SELECT City FROM Suppliers

Previous

Next