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
- 27042 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / vikatakavi08
select * from emp where rownum<=100 and rownum>=200;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between drop table and delete table?
Where do you specify them?
What is the use of with ur in db2?
How do I connect my db2 database to ibm?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is cursor with hold option in db2?
How can you find out the # of rows updated after an update statement?
How can you do the explain of a dynamic sql statement?
What is cursor stability in db2?
What do you mean by between and in? Is between inclusive of specified range values?
Define db2 and its databases?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is release/acquire in bind?
What is the role of the data page in the db2 database?
How and when does the db2 enforces the unique key?
