OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL Query

Mon, 25 August 2003 05:48

sridhar
Messages: 119
Registered: December 2001

Senior Member

How to get the 4th and 5th record using select statement?

Mon, 25 August 2003 07:47

Amit
Messages: 166
Registered: February 1999

Senior Member

select * from table where rownum <= 5
minus
select * from table where rownum <4

Mon, 25 August 2003 21:55

Shailender Mehta
Messages: 49
Registered: June 2003

Member

select col1, col2, ..... coln, rnum
from ( select col1
,col2
,...
,coln
, rownum rnum
from

)
where rnum in (4,5)

Previous Topic:	text column comparison
Next Topic:	Structural Changes

Goto Forum:

]

Current Time: Thu Apr 25 11:51:19 CDT 2024