OraFAQ Forum: Server Administration » returning only certain rows from a query

Home » RDBMS Server » Server Administration » returning only certain rows from a query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

returning only certain rows from a query [message #371700]

Mon, 27 November 2000 14:49

Paul
Messages: 164
Registered: April 1999

Senior Member

I would like to select say rows 5-20 from the results of a query. I know how to get the first n rows, but I would like to get the nth through the n+nth rows. Is that possible?

Report message to a moderator

Re: returning only certain rows from a query [message #371701 is a reply to message #371700]

Mon, 27 November 2000 15:11

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi Paul,

Use this example

select * from
(
select rownum rnum, a.*
from (select *
from t1) a
where rownum <= 20
)
where rownum >= 5;

Bala.

Report message to a moderator

Re: returning only certain rows from a query [message #371702 is a reply to message #371701]

Mon, 27 November 2000 15:29

Paul
Messages: 164
Registered: April 1999

Senior Member

I tried this with my Oracle SQL client and it would not work. Taking out the >=5 it does work. I think the rownum checking only works when doing <=. Am I wrong?

Report message to a moderator

Sorry i over looked....... [message #371704 is a reply to message #371701]

Mon, 27 November 2000 15:45

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

It should be where rnum >= 5

select * from
(
select rownum rnum, a.*
from (select *
from client_names) a
where rownum <= 20
)
where rnum > 5
/

Bala

Report message to a moderator