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

How does a self join work?

1133

Is sql harder than python?

1110

Why is sql important?

1115

How do I start sql from command line?

1027

Which are sql * plus commands?

1132

How many commands are in sql?

1074

What is the difference between count 1 and count (*) in a sql query?

1000

Explain the difference between triggers and constraints?

982

What is indexing in sql and its types?

1083

What is difference between stored function and application function?

1209

How do you break a loop in pl sql?

1055

How do I clear the screen in sql plus?

1049

what is the difference between char_length and length? : Sql dba

1050

What are functions in sql?

962

Why do we use %rowtype & %type in plsql?

1055