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
9519 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

When you have to use a default "rollback to" savepoint of plvlog?

1182

How to use sql statements in pl/sql?

1111

How to use boolean type in select statement?

1065

What is a pl/sql block?

1210

How can check sql version from command line?

1074

Explain table and field in sql?

1058

Why do you partition data?

1016

How does cross join work in sql?

1007

Who is the owner of mysql database?

1053

What is trigger point?

986

Is ms sql is free?

1017

Is sql injection illegal?

1011

what is the difference between primary key and unique key? : Sql dba

1028

Explain autonomous transaction.

1152

How do you write an index?

962