At 09:22 AM 4/15/05, DebugasRu wrote:
taken from the manual 3.6.2 The Row Holding the Maximum of a Certain Column
which of the two queries will in general be faster:
1)
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
2)
SELECT article, dealer, price
FROM shop
taken from the manual 3.6.2 The Row Holding the Maximum of a Certain Column
which of the two queries will in general be faster:
1)
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
2)
SELECT article, dealer, price
FROM shop
ORDER BY price DESC
LIMIT 1;
or do
Which one is faster in mySql api ou odbc, why is it faster and how much
?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
