How do you retrieve set of records from database server. {Set max records = 1

How do you retrieve set of records from database server.

{Set max records = 100 & use paging where pager page no or
records = 10 & after displaying 100 records again connect to
database retrieve next 100 }

Question Posted / hemanth desai

2 Answers
8938 Views
DELL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do you retrieve set of records from database server. {Set max records = 100 & use paging ..

Answer / pandu

Hi the above posted Querry is wrong

this is Correct

Select * from TableName
where rowid in(
Select rowid from TableName
where rownum =&upto(EX <=100,200
minus
select rowid from TableName
where rownum<=&from(EX =1,101)
)

Is This Answer Correct ?

8 Yes

2 No

How do you retrieve set of records from database server. {Set max records = 100 & use paging ..

Answer / padma

select top 100 * from <tablename>

Is This Answer Correct ?

0 Yes

7 No

Post New Answer