Re: SKIP command in version 9.4

Andrew2006 wrote: > Hello, > > The SKIP command doesn't appear to be part of Informix 9.4 but is > there an equivalent? > > I want to do a query like: > > SELECT SKIP 50 FIRST 10 * FROM <tablename>> > > In mysql this would be done as: > > SELECT * FROM <tablename> LIMIT 50,10> > Thanks > > Andrew > Upgrade to IDS version 10. It has SKIP, FIRST, MIDDLE, LIMIT