- All Exams Instant Download
What should you do?
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.
Answer: C
Explanation:
Reference: https://www.techonthenet.com/sql/union_all.php
Latest Professional Cloud Developer Dumps Valid Version with 75 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments