[Solved] Which of the following is the correct syntax to find rows in table1 not in table2 using EXCEPT? — Ans: SELECT * FROM table1 EXCEPT SELECT * FROM table2; | SQL

SQL - Set Operations

Which of the following is the correct syntax to find rows in table1 not in table2 using EXCEPT?

ASELECT * FROM table1 WHERE NOT IN table2;

BSELECT * FROM table1 MINUS table2;

CSELECT * FROM table1 EXCEPT SELECT * FROM table2;

DSELECT * FROM table1 JOIN table2 EXCEPT;

Step-by-Step Solution

Solution:

Step 1: Recall correct EXCEPT syntax
The EXCEPT operator is used between two SELECT statements: SELECT ... FROM ... EXCEPT SELECT ... FROM ....
Step 2: Check each option
SELECT * FROM table1 EXCEPT SELECT * FROM table2; uses correct syntax with two SELECT statements separated by EXCEPT. SELECT * FROM table1 MINUS table2; is incorrect because MINUS requires SELECT before both tables. SELECT * FROM table1 WHERE NOT IN table2; is invalid syntax. SELECT * FROM table1 JOIN table2 EXCEPT; misuses JOIN and EXCEPT.
Final Answer:
SELECT * FROM table1 EXCEPT SELECT * FROM table2; -> Option C
Quick Check:
Correct EXCEPT syntax = SELECT ... EXCEPT SELECT ... [OK]

Quick Trick: EXCEPT goes between two SELECT queries, no JOIN needed [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to find rows in table1 not in table2 using EXCEPT?