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
List different type of expressions with the example.
How does one load ebcdic data? : aql loader
What does select top 1 do in sql?
Explain locks? : Transact sql
Which command is used to delete a trigger?
is it possible to pass an object or table to a procedure as an argument?
What is the difference between nvl function, ifnull function, and isnull function?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is left join in postgresql?
What is right join in sql?
How do you modify a column in sql?
How does stored procedure reduce network traffic?
What is the use of sqldataadapter?
What is the basic form of sql query?
When can we use the where clause and the having clause?