On Fri, 31 Mar 2006 13:07:03 -0500 Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
> > On Mar 31, 2006, at 12:56 PM, [EMAIL PROTECTED] wrote: > > PostgreSQL uses LIMIT 10 OFFSET 20 where mysql uses LIMIT 20,10 > > (notice > > the swap). I don't know if it is "standard", but if it is, vendors > > aren't following the standard. > > There's no SQL standard for Limit and Offset. Yup, you're right I just double checked and there isn't a LIMIT/OFFSET in the SQL standard. For someone reason... probably because it's so freaking useful, I assumed it was. :) --------------------------------- Frank Wiles <[EMAIL PROTECTED]> http://www.wiles.org ---------------------------------
