Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
- 17 Answers
- 26758 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / prasenjit
Yes and no in both ways.
I know there is a Roid() Over() function DB2 release 7
onwards and that shld solve the problem.
But what if there was condition that you cant use these
functions.
Cant there be any query that can produce the req result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can the duplicate values be eliminated from db2 select?
What's The Percentage Free Space ?
Give a brief description of db2 isolation levels?
What is isolation level in db2?
What is the difference between db2 and oracle?
What is the difference between plan and package in db2?
Which isolation level provides maximum concurrency?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
List down the types of triggers in the db2 database?
List out the three types of page locks that can be held.
What is dclgen (declaration generator)?
What is innodb buffer pool?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What are the 2 sqlcodes that are returned?
What is rct?
