Oracle Tutorial

Rownum Examples

Example 1

Select rownum, type, name
From jobs
Where rownum > 1200 ; Order By name;

Example 2

Select * From
(Select * From jobs Order By job_id)
Where rownum < 100 ;



Example 3

Select name, sal From
(Select name, sal
From jobs
Order By name asc, sal desc )
Where rownum < 325 ;