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

Explain the working of primary key?

1038

Can a key be both primary and foreign?

946

what is 'mysqlcheck'? : Sql dba

960

What are the different types of constraints?

1074

What are the benefits of triggers?

1122

What is pl sql package?

993

What are the differences between in and exists clause?

1050

Can instead of triggers be used to fire once for each statement on a view?

896

Can we use having without group by in sql?

929

Can we join more than 2 tables in sql?

950

what is recursive stored procedure? : Sql dba

932

Explain the purpose of %type and %rowtype data types?

875

Explain the significance of the & and && operators in pl sql.

951

How do rank () and dense_rank () differ?

977

What is a loop in sql?

937