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
- 9445 Views
- DELL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
Which join is like inner join?
Explain the working of primary key?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
What is difference between db2 and sql?
Why self join is used in sql?
What is trigger in sql and its types?
What is the most restrictive isolation level? : Transact sql
What is the difference between subquery and correlated query?
In packages the source code is compiled into p code ? how do we describe the p code
What is difference between hql and sql?
What is the difference between delete and truncate commands?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
