Re: Is there such a thing as a sub-select in Informix--HELP!!!
> SELECT FIRST 50 *
> FROM (
> SELECT FIRST 250 *
> FROM TABLE
> ORDER BY column DESC
> )
> ORDER BY column ASC;
Haven't tested it, but what about:
SELECT FIRST 50 * FROM TABLE WHERE column IN
(SELECT FIRST 250 * FROM TABLE ORDER BY column DESC)
ORDER BY column ASC;
Good Idea, but it Informix doesn't allow FIRST or ORDER BY in subqueries,
views, or INSER INTO statements.
Chuck Renaud <chuck.renaud@informix.com> wrote in message
news:8o4s05$slq$1@news.xmission.com...
>
> > SELECT FIRST 50 *
> > FROM (
> > SELECT FIRST 250 *
> > FROM TABLE
> > ORDER BY column DESC
> > )
> > ORDER BY column ASC;>
> Haven't tested it, but what about:
>
> SELECT FIRST 50 * FROM TABLE WHERE column IN
> (SELECT FIRST 250 * FROM TABLE ORDER BY column DESC)
> ORDER BY column ASC;>