Which of the following is the correct syntax to find common rows between two tables Table1 and Table2?

easy📝 Syntax Q3 of 15

SQL - Set Operations

Which of the following is the correct syntax to find common rows between two tables Table1 and Table2?

ASELECT * FROM Table1 JOIN Table2;

BSELECT * FROM Table1 UNION SELECT * FROM Table2;

CSELECT * FROM Table1 EXCEPT SELECT * FROM Table2;

DSELECT * FROM Table1 INTERSECT SELECT * FROM Table2;

Step-by-Step Solution

Solution:

Step 1: Review syntax for INTERSECT
The correct syntax uses SELECT * FROM Table1 INTERSECT SELECT * FROM Table2 to get common rows.
Step 2: Eliminate incorrect options
UNION combines all rows, JOIN requires ON clause, EXCEPT returns rows only in first table.
Final Answer:
SELECT * FROM Table1 INTERSECT SELECT * FROM Table2; -> Option D
Quick Check:
Correct INTERSECT syntax = SELECT * FROM Table1 INTERSECT SELECT * FROM Table2; [OK]

Quick Trick: Use INTERSECT between two SELECT queries for common rows [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes