OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Row count

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

Row count [message #36200]

Fri, 09 November 2001 09:30

Panneer Selvam
Messages: 7
Registered: November 2001

Junior Member

I have a table with 100 rows.I need to select 10 rows at a time . ie first from 1 to 10 , 11 to 20 and so on.

I tried the following query.

SELECT * FROM table WHERE ROWNUM BETWEEN 1 AND 10

The above query worked but the following didn't

SELECT * FROM table WHERE ROWNUM BETWEEN 11 AND 20

Pl. help

----------------------------------------------------------------------

Report message to a moderator

Re: Row count [message #36201 is a reply to message #36200]

Fri, 09 November 2001 09:42

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

try this:

select * from (select rownum rnm,col_name from table) a
where a.rnm between 11 and 20;

----------------------------------------------------------------------

Report message to a moderator

Re: Row count [message #36203 is a reply to message #36200]

Fri, 09 November 2001 09:47

James Bradburn
Messages: 4
Registered: November 2001

Junior Member

You could use a cursor to get all the rows and cycle through them in groups of ten. More details would allow the best solution to be found.

----------------------------------------------------------------------

Report message to a moderator

Re: Row count [message #36205 is a reply to message #36201]

Fri, 09 November 2001 10:06

Panneer Selvam
Messages: 7
Registered: November 2001

Junior Member

Thankyou Suresh

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Droping Temporary Table
Next Topic:	COLUMN INTO ROWS AND VICE VERSA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 31 05:47:31 CDT 2025