Get range of rows from a table.

[lakshmivaragan]

Hi,
Is there any way to get a range of rows from a table.
For e.g to get rows 10 to 15 from a table ?

(ROWNUM is no good. Since > wont work with ROWNUM. We cant have query like this
SELECT * FROM EMP WHERE ROWNUM > 10 and ROWNUM < 15
)

Is there any other way ???

Regs
Lax

 

[stefanhei]

Use Inlineviews:
SELECT what,you,need
FROM (SELECT rownum rn,t.*
FROM yourTable t
WHERE yourCondition=true
ORDER BY sortfield)
WHERE rn between 10 and 15
Better use the analytic row_number-function instead of the rownum-pseudocolumn if you don't work on a simple table (use aggregatefunctions, joins,...).

Stefan