The UNION command eliminates the duplicates and the UNION ALL command retains the duplicates while combining the results of the different SELECT statements.

BY Best Interview Question ON 09 Feb 2019
Post Your Suggestion

Suggest An Answer

More Interview Questions from Database
SQL Interview Questions MySQL Interview Questions
DBMS Interview Questions Rdbms Interview Questions
MongoDB Interview Questions SQLite Interview Questions
Oracle Interview Questions MariaDB Interview Questions
SAP Hana Interview Questions Teradata Interview Questions