You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a single table, removing duplicate rows from the result set.
What should you do?
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.
You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a sin
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You have two tables in an ANSI-SQL compliant database with identical columns that you need to quickly combine into a sin
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!