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

Y2K wrote in message <376fd27c.333723959_at_news.concentric.net>...
>Thanks for the reponse! But how do I handle the order by clause? My
>select will be sorted according to user input (ie dynamically), and it
>has to be sorted first, and then select rows from 150 to 199 etc.
>

A solution lies in something i wrote in an earlier thread...

'Combining all this, why don't you do your initial query, save it to a temp table in the order you want and then use the rownum method stated below based on the sorted temp table?'

Instead of a temp table, you can also consider a PL/SQL table. Received on Wed Jun 23 1999 - 03:08:15 CDT