What Will Be The Result Of The Following Queryp Pre Langsql #13
What will be the result of the following query?</p> <pre><code class="language-sql"> (select studentid from student where section = 'c') except (select studentid from student where roll <10); </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 - Set Operations - Quiz No.1.
What will be the result of the following query?
(select studentid from student where section = 'c') except (select studentid from student where roll <10);
All the values of the studentid for which section is c and roll < 10
All the values of the studentid for which section is c and roll > 10
All the values of the studentid for which section not c and roll < 10
All the values of the studentid for which section not c and roll > 10