Hi the above posted Querry is wrong this is Correct Select * from T

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 / pandu

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql developer case sensitive?

951

explain normalization concept? : Sql dba

1005

Can we use ddl statements in stored procedure sql server?

974

What does pl sql developer do?

889

How do we use distinct statement? What is its use?

985

How do I run a program in pl sql?

966

what are the differences among rownum, rank and dense_rank? : Sql dba

999

What is difference between hql and sql?

1004

What is sql in java?

1036

What is dynamic sql in pl sql?

992

How does pl sql work?

922

What is type and rowtype in pl sql?

978

What is pivot table in sql?

1032

What is a sql schema used for?

1045

Can you join views in sql?

909