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 }
- 2 Answers
- 8943 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
What is autocommit sql?
what is the difference between a web-garden and a web-farm? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How to run sql commands in sql*plus?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is secondary key?
What are the different operators available in sql?
Does pl/sql support create command?
What is difference between function and trigger?
Can cursors be part of a trigger body?
What does the base_object_type column shows in the user.triggers data dictionary view?
How does sql profiler work?
What are the 3 types of behavioral triggers?
What is dba in sql? : SQL DBA
What is a pragma statement?
