2 replies to this topic

[Hamed]

Is it possible that I use this

SELECT *
FROM orders
WHERE (SELECT MAX(day)) = (SELECT MAX(day_of_order)) FROM orders

[wim DC]

Not like you wrote it, with 2 separate SELECTS you can:

WHERE (SELECT MAX(day) FROM orders) = (SELECT MAX(day_of_order) FROM orders)

Note that this will select every row from the orders table if it is true.

[LuthfiHakim]

Although popular db nowadays already support it, but first you must check your database to see if it's supporting subquery. And if it supports subquery, I believe you must rephrase your query, just like win DC mentioned. Maybe you could explain what are you trying to achieve using subquery?