SEO

#1 (**permalink**) 04-20-2008, 03:33 PM

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

#2 (**permalink**) 04-20-2008, 03:33 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SKIP command in version 9.4