Home » RDBMS Server » Server Administration » Select selected rows at a time
Select selected rows at a time [message #371982] Sat, 30 December 2000 01:44 Go to next message
sri
Messages: 154
Registered: February 2000
Senior Member
hi,

I want to select 10 rows each time from a particular query. This for a web page once Next>> button is pressed next 10 records to be fetched. Please suggest me the SQL. My table is having ~100,000 records,

Thanks in advance

regards,

Sri

Report message to a moderator

Re: Select selected rows at a time [message #372009 is a reply to message #371982] Wed, 03 January 2001 12:41 Go to previous messageGo to next message
Ravi Prasad
Messages: 9
Registered: January 2001
Junior Member
select * from
(
select * from tname where rownum <= 20
minus
select * from tname where rownum < 10)

Report message to a moderator

Re: Select selected rows at a time [message #373763 is a reply to message #371982] Mon, 07 May 2001 02:06 Go to previous message
sri
Messages: 154
Registered: February 2000
Senior Member
infact i also have the same problem of retrieving specified numbers. u got a better solution for this problem. pl. mail me if u got a workable solution without any performance hinderance. thanks in advance.

Report message to a moderator

Previous Topic: Date
Next Topic: SQLPLUS help please
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 16:49:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.