Choose The Correct Option Regarding The Following Queryp Pre #34

Choose the correct option regarding the following query</p> <pre><code class="language-sql">with max_marks (value) as (select max(marks) from student) select studentID from student,max_marks where student.marks = max_marks.value;</code></pre>

This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Introduction to Relational Model and SQL - Nested Subqueries - Quiz No.1.

with max_marks (value) as (select max(marks) from student) select studentID from student,max_marks where student.marks = max_marks.value;