Home >> SQL >> Union all in SQL

Union all in SQL

The UNION ALL does not remove duplicate records.

Both relations or table must have same number of columns.

The UNION ALL operator is used to combine the result sets of two or more SELECT statement.

Example

SELECT supplier_id FROM suppliers UNION ALL SELECT supplier_id FROM orders

Post Your Comment

Next Questions
Exits
Not Exits
Any
All
Max
Min
Avg
Count
Sum

Copyright ©2022 coderraj.com. All Rights Reserved.