[Solved] Which of the following is the correct syntax to start a CTE in SQL? — Ans: WITH cte_name AS (SELECT * FROM table_name) | SQL

SQL - Common Table Expressions (CTEs)

Which of the following is the correct syntax to start a CTE in SQL?

AWITH cte_name AS (SELECT * FROM table_name)

BCREATE CTE cte_name SELECT * FROM table_name

CDEFINE cte_name AS SELECT * FROM table_name

DSTART CTE cte_name (SELECT * FROM table_name)

Step-by-Step Solution

Solution:

Step 1: Recall standard CTE syntax
The correct way to define a CTE is using the WITH keyword followed by the CTE name and AS, then the query in parentheses.
Step 2: Check other options for syntax errors
Options A, C, and D use incorrect keywords like CREATE, DEFINE, or START which are not valid for CTEs.
Final Answer:
WITH cte_name AS (SELECT * FROM table_name) -> Option A
Quick Check:
CTE starts with WITH ... AS (...) = B [OK]

Quick Trick: CTEs always start with WITH keyword [OK]

Common Mistakes:

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to start a CTE in SQL?