look at the LIMIT command LIMIT (n,1)
something like that On Fri, 21 Jan 2005 11:06:23 +1000 (GMT+10:00), Ayudh Nagara <[EMAIL PROTECTED]> wrote: > > > Hi y'all, > select top N returns the first N records in an ordered query. Is there SQL to > return *only* the Nth record? > > Regards: Ayudh > > +----------------------------------------------------------------+ > | SOAP is the glue! Hook up your server directly to your bank. | > | Connect to VeriPay xServ, the Australian Payments Web Service. | > | Reliable, Secure, FAST: http://www.xilo.com/xserv | > +----------------------------------------------------------------+ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
