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]
