Afficher un message
Vieux 04/10/2007, 17h00   #1
yawnmoth
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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

  Réponse avec citation
 
Page generated in 0,03980 seconds with 9 queries