At 01:12 AM 7/20/2003, you wrote:
my table is small but I can't tell what is faster.. a max or a limit
mysql select max(counter) from web;
mysql select counter from web order by counter desc;
They seem to be the same in performance.
Regards,
Jake Johnson
[EMAIL PROTECTED]
Jake,
I tried
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light on this?
TIA
--
MySQL General
At 13:32 -0400 7/20/03, C. Reeve wrote:
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light
At 12:32 PM 7/20/2003, you wrote:
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light on