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!
Answer Posted / mvramesh
How about combingin two queries with set operator EXCEPT,
if you have query A EXCEPT query B, the result would be A-B.
Select * from table A fetch first 200 rows only
Union except
Select * from table A fetch first 100 rows only
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are the contents of dclgen?
How to test SQL -911 error while developing COB-DB2 program
What are the full forms of spufi and dclgen and why are they used?
What is iseries database?
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 package in cobol db2?
What is ibm db2 used for?
What is db2 connect?
What is consistency token in db2?
What does db2 plan contain?
what is diffrence b/w file-aid tool and file-aid utility???
What is dbrm? What it contains? When it will be created?
What db2 400?