Question

_______ clause creates temporary relation for the query on which it is defined.

Select the correct answer from below options:

a) WITH

b) FROM

c) WHERE

d) SELECT

Answer 1

WITH clause creates temporary relation for the query on which it is defined.

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.