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.
SELECT supplier_id FROM suppliers UNION ALL SELECT supplier_id FROM orders
Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.
Copyright ©2022 coderraj.com. All Rights Reserved.