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 }
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
Is sql free?
Why indexing is needed?
How many tables can you join in sql?
When you have to use a default "rollback to" savepoint of plvlog?
How to get help at the sql prompt?
How do I count rows in sql query?
Explain table and field in sql?
What is group by in sql?
What are the disadvantages of not performing database normalization?
How to run pl sql program in mysql?
how is exception handling handled in mysql? : Sql dba
How do I edit a stored procedure?
Can we use insert statement in function?
what are the different functions in sorting an array? : Sql dba
How many commands are in sql?