Microsoft Certified Azure Enterprise Data Analyst Associate · Free Practice Question Easy
Question 17
What is the purpose of the EXCEPT function in SQL?
- A To output all rows that are in the first table but not in the second table
- B To combine rows from two tables and remove duplicates
- C To output all rows that are common to both tables
- D To compare columns based on their positions
Reveal correct answer
Correct answer: A
Explanation
The EXCEPT function is used to output all rows that are in the first table but not in the second table.Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
