Identify the error in the following SQL statement:

medium📝 Debug Q6 of 15

SQL - Set Operations

Identify the error in the following SQL statement:
SELECT id FROM table1 UNION ALL SELECT FROM table2;

AMissing semicolon at the end

BUNION ALL cannot be used with SELECT

CMissing column name after second SELECT

DTable names must be the same

Step-by-Step Solution

Solution:

Step 1: Check second SELECT syntax
The second SELECT is missing the column name after SELECT.
Step 2: Validate UNION ALL usage
UNION ALL is valid with SELECT statements having matching columns.
Final Answer:
Missing column name after second SELECT -> Option C
Quick Check:
Syntax error = missing column name [OK]

Quick Trick: Each SELECT must specify columns before UNION ALL [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