SQL - Common Table Expressions (CTEs)
Which of the following is the correct way to declare two CTEs named
first_cte and second_cte in a single SQL query?Which of the following is the correct way to declare two CTEs named first_cte and second_cte in a single SQL query?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Understand CTE syntax
Multiple CTEs are declared after a single WITH keyword, separated by commas.Step 2: Analyze each option
WITH first_cte AS (SELECT * FROM table1), second_cte AS (SELECT * FROM table2) SELECT * FROM second_cte; correctly uses WITH once, defines both CTEs with AS and parentheses, and separates them by a comma.Step 3: Identify errors in other options
WITH first_cte (SELECT * FROM table1); WITH second_cte (SELECT * FROM table2); SELECT * FROM second_cte; incorrectly uses multiple WITH keywords; WITH first_cte = (SELECT * FROM table1), second_cte = (SELECT * FROM table2) SELECT * FROM second_cte; uses '=' instead of AS; WITH first_cte AS SELECT * FROM table1, second_cte AS SELECT * FROM table2 SELECT * FROM second_cte; misses parentheses around SELECT statements.Final Answer:
Option A -> Option AQuick Check:
Single WITH, commas separate CTEs, AS with parentheses [OK]
Quick Trick: Use one WITH, separate CTEs by commas [OK]
Common Mistakes:
- Using multiple WITH keywords for multiple CTEs
- Omitting parentheses around CTE SELECT statements
- Using '=' instead of AS to define CTEs
Master "Common Table Expressions (CTEs)" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes