Имеется таблица Women

+-----+-----------+-------+
|  Id | FirstName | Score |
+-----+-----------+-------+
|   1 | Gwyneth   | 1000  |
|   3 | Jennifer  |  800  |
|   4 | Paris     | NULL  |
|   5 | Misha     | 3000  |
+-----+-----------+-------+
how many records will the following query return:

SELECT FirstName, Score FROM Women
WHERE Score >= ANY (SELECT Score FROM Women
                    WHERE FirstName='Megan');
Explanation
Whenever subquery is unable to return records, ANY operator automatically evaluates to False.
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback