____ clause creates temporary relation for the query on which it is defined.
2023
____ clause creates temporary relation for the query on which it is defined.
- A.
WITH
- B.
FROM
- C.
WHERE
- D.
More than one of the above
- E.
None of the above
Attempted by 1088 students.
Show answer & explanation
Correct answer: A
The correct answer is WITH. The WITH clause in SQL is used to define a temporary result set, also known as a common table expression (CTE), which can be referenced within a query. This temporary relation exists only for the duration of the query execution.