[Solved] Find the error in this query:SELECT id FROM table1 INTERSECT table2; — Ans: Missing SELECT statement for second query | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

Find the error in this query:
SELECT id FROM table1 INTERSECT table2;

AINTERSECT cannot be used with tables directly

BTable names cannot be used in INTERSECT

CMissing semicolon at end

DMissing SELECT statement for second query

Step-by-Step Solution

Solution:

Step 1: Check syntax for INTERSECT
INTERSECT requires two SELECT statements, not just table names.
Step 2: Identify missing SELECT
The second query should be SELECT id FROM table2.
Final Answer:
Missing SELECT statement for second query -> Option D
Quick Check:
INTERSECT needs two SELECTs [OK]

Quick Trick: Use SELECT in both queries with INTERSECT [OK]

Common Mistakes:

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Find the error in this query: