For the following table 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.

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Cosmo
Sign Up Now
or Subscribe for future quizzes