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

Interview Questions

Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.