Posted by Shelly on 12/01/07 10:43
Ciaran wrote:
> I have a result resource from a large mysql query and I need to find
> the single the highest value from a certain field. What's the best way
> to pull it off?
> Cheers,
> Ciarαn
A simple google of "sql max" would have led you to:
SELECT MAX(expression )
FROM tables
WHERE predicates;
--
Shelly
[Back to original message]
|