Re: Select ranges of rows

"Kalamaro" <diegoman_at_usuarios.retecal.es> wrote in message news:a5bs3b$67a5g$1_at_ID-115330.news.dfncis.de...
> Hi. I have a problem selecting a range of rows. What i want is to
get the
> rows from X to Y in a specific order. I've found that:
>
> SELECT *
> FROM tableX
> WHERE rowid in (
> SELECT rowid FROM tableX
> WHERE rownum <= 7
> MINUS
> SELECT rowid FROM tableX
> WHERE rownum < 5);
>
> It works, but it's hard to apply it to my query. Is there another
way to do
> the same (with views or something else)?

Is your end-goal to provide the front-end the ability to page through the dataset? If so, there are less taxing methods to do this.

--
Pablo Sanchez, High-Performance Database Engineering
www.hpdbe.com
Available for short-term and long-term contracts