SELECT MAX vs. SELECT / ORDER BYDESC / LIMIT
I'm curious - which query is generally faster?:
SELECT MAX(order_total) AS order_max
FROM orders
WHERE customer = ...
....or...
SELECT order_total AS order_max
FROM orders
WHERE customer = ...
ORDER BY order_total DESC
LIMIT 1
|