Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the correct ANSI-SQL compliant method to combine two tables with identical columns into a single table while removing duplicate rows?
A
Use the JOIN operator in SQL to combine the tables.
B
Use nested WITH statements to combine the tables.
C
Use the UNION operator in SQL to combine the tables.
D
Use the UNION ALL operator in SQL to combine the tables.
