Question

Which of the following creates a temporary relation for the query on which it is defined?

(a) With

(b) From

(c) Where

(d) Select

Answer 1

The correct option is (a) With

Easy explanation - The with clause provides a way of defining a temporary relation whose definition is available only to the query in which the with clause occurs.