Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9637 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
How do I sort a table in sql?
Can we enter data in a table in design view?
What are few of the schema objects that are created using PL/SQL?
what is the difference between truncate and drop statements? : Sql dba
what are the authentication modes in sql server? : Sql dba
What is the difference between local variables and global variables?
How do I turn a list into a table?
Why do we use triggers?
What is the use of function in sql?
What are the different ddl commands in sql?
what does it mean to have quoted_identifier on? : Sql dba
Why do we use function in pl sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How do sql triggers work?
What is the purpose of primary key?
