SQL quiz. Given Products table <pre><code class="sql">+-----

Given Products table

+--------+-----------+
|   ID   |   Price   |
+--------+-----------+
|  1001  |   1300    |
|  1002  |    600    |
|  1003  |   2500    | 
|  1004  |   1600    |
+--------+-----------+

Which of the queries will have a result identical to that of the following query:

SELECT * FROM Products
WHERE Price = (SELECT MAX(Price) FROM Products);


SELECT *
FROM Products
WHERE Price > ALL (SELECT Price FROM Products);


SELECT *
FROM Products
WHERE Price >= ALL (SELECT Price FROM Products);


SELECT *
FROM Products
WHERE Price > ANY(SELECT Price FROM Products);


SELECT *
FROM Products
WHERE Price >= ANY (SELECT Price FROM Products);


SELECT *
FROM Products AS P1
WHERE EXISTS (SELECT * FROM Products AS P2 WHERE P1.price > P2.price);


SELECT *
FROM Products AS P1
WHERE NOT EXISTS (SELECT * FROM Products AS P2 WHERE P1.price < P2.price);


SELECT P1.*
FROM Products AS P1, (SELECT MAX(price) AS maxprice FROM Products) AS P2
WHERE price=maxprice;

Explanation

First of all, we need strict inequality to be used in WHERE clause (>= instead of >) to find the maximum price.
Second of all, when choosing between ALL and ANY operators, we should go with ALL. ANY operator returns true if any of the subquery values meet the condition. While ALL operator returns true if all of the subquery values meet the condition.

Like

Login in to like
Comment

Login in to comment
Share

Tweet

SQL
Quiz

or Read more about SQL Quizzes

Follow CodeGalaxy

Mobile Beta

Send Feedback