you need LIMIT http://www.mysql.com/doc/en/LIMIT_optimisation.html
> -----Original Message----- > From: Douglas McKenzie [mailto:[EMAIL PROTECTED]] > Sent: 17 January 2003 16:53 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] SQL > MySql > > > SELECT max(OrderID) as maxOrderID > > that works > > Cheers Giles > > -----Original Message----- > From: Giles Roadnight [mailto:[EMAIL PROTECTED]] > Sent: 17 January 2003 16:48 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] SQL > MySql > > > SELECT TOP 1 max(OrderID) as maxOrderID ??? > > ----- Original Message ----- > From: "Douglas McKenzie" <[EMAIL PROTECTED]> > To: "CF-Dev" <[EMAIL PROTECTED]> > Sent: Friday, January 17, 2003 4:46 PM > Subject: [ cf-dev ] SQL > MySql > > > > Got that Friday feeling so Im hoping someone can help. > > > > Need to convert this SQL: > > > > SELECT TOP 1 as maxOrderID > > > > into a statement that will work with MySql. > > > > Any ideas? > > > > Cheers, > > Douglas McKenzie > > > > ---------------------------------------- > > Internet Developer / Designer > > [EMAIL PROTECTED] > > 020 7267 6718 > > ---------------------------------------- > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
