Question 70Asked in BPSC TRE 1.0 (2023) Computer Science Class 11-12

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

  1. AWITH
  2. BFROM
  3. CWHERE
  4. DMore than one of the above
  5. ENone of the above
Show answerHide answer

Correct answer: (A) WITH

Explanation

The WITH clause (a common table expression) defines a temporary named relation that exists only for that query.

From BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper

This is question 70 of BPSC TRE 1.0 (2023) Computer Science Class 11-12 — Previous Year Paper. See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.