In The Query Given Above Which One Of The Following Is A #164

In the query given above which one of the following is a temporary relation?</p> <pre><code class="language-sql">With max_budget (value) as (select max(budget) from department) select budget from department, max_budget where department.budget = max budget.value; </code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs116 Microsoft SQL Server. It can also be found in gs gs116 Manipulating Data with Select - Modifying Data - Quiz No.2.

With max_budget (value) as (select max(budget) from department) select budget from department, max_budget where department.budget = max budget.value;