______ clause creates temporary relation for the query on which it is defined.
Answer with explanationAnswer: Option B
The WITH clause in SQL allows us to provide a sub-query block, a name that can be referenced in several places within the main query. It is used for defining a temporary relation whose definition is available by the query in which the WITH clause is associated.
Discuss about the question