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
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]
_
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 thi
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
