Thank you for correction. You are absolutly right!
Best regards,
Mikhail.
----- Original Message -----
From: "Brian Mansell" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: "A Z" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 12, 2004 10:11 AM
Subject: Re: Max
> Just a minor correction...
>
> select YourField from YourTable order by YourField DESC limit 1;
>
> ('DESC' in order to return the greatest value first)
>
> On Tue, 11 May 2004 17:28:05 +0200, Mikhail Entaltsev
> <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > select YourField from YourTable order by YourField limit 1;
> >
> > Best regards,
> > Mikhail.
> >
> >
> > ----- Original Message -----
> > From: "A Z" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, May 11, 2004 3:01 PM
> > Subject: Max
> >
> > >
> > > Hi,
> > >
> > > A field of type VarChar() with following syntax:
> > > ABA1.
> > > How to get the Max value. Bearing in mind that value
> > > ABA10 comes before ABA2.
> > >
> > > regards
> > >
> > >
> > >
> > >
> > >
> > >
> > > ____________________________________________________________
> > > Yahoo! Messenger - Communicate instantly..."Ping"
> > > your friends today! Download Messenger Now
> > > http://uk.messenger.yahoo.com/download/index.html
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> > >
> > >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
