Yes that should be possible (depending on how your table is designed). If
you just want the largest number do something like:
select Number from Table order by Number desc limit 1
Best regards,
Martin Edelius
Spirex Digital Design
--------------------------------
www: http://www.spirex.se
Mail: martin.edelius@stripped
Phone: +46-31-514651, 0708-113711
Fax: +46-31-514331
Aröds Industriväg 3c
S-422 43 Hisings Backa
--------------------------------
If I haven't got back to you or done what I'm supposed to, let me know again
as I have too much to do for my own good...
----- Original Message -----
From: "Oleg Timofeyev" <olegtim@stripped>
To: <mysql@stripped>
Sent: Friday, February 25, 2000 6:11 PM
Subject: Finding largest number in a field
> Hi,
>
> I was wondering is it possible to query a table and fetch the largest
number
> out of thousands of rows or should I use some programming for that?
>
> Sincerely,
> Oleg Timofeyev
> 2xdigi.com
> (818)476-0076
> olegtim@stripped
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread29072@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-martin.edelius=spirex.se@stripped>
>
>
