Re: Q: returning rows between two positions in a large query

You might try an inline view that return the rownumber. You can then restrict the numer of fields, e.g.

select empid, rowNumber from emp,
(select empid as id, rownum as rowNumber from emp) x where empid = id
and rowNumber between 2 and 5

HTH Dieter

Y2K schrieb:

> I have a large select query that returns rows from a table in
> different sort orders depending on user inputs, and I wonder if there
> is any way to return just the rows between two specified positions?
>
> For example, let's say the query returns 2000 rows (in different
> orders depending on user input), and I only want 50 rows from #150 to
> #199.
>
> An analogy would be when you go to yahoo and do a search, and the
> results are broken down into various pages. I want to do the same
> thing in my web app.
>
> TIA!
Received on Wed Jun 23 1999 - 05:30:56 CDT