What Is The Result Of The Following Queryp Pre Langsql #28
What is the result of the following query?</p> <pre><code class="language-sql">select studname from college where marks > some (select marks from student where section = 'c');</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.
What is the result of the following query?
select studname from college where marks > some (select marks from student where section = 'c');
The query gives all the studnames for which marks are greater than all the students in section c
The query gives all the studnames for which the marks are greater than at least on student in section c
The query gives all the studnames for which the marks are less than all the students in section c
The query is syntactically incorrect
