Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?
- 4 Answers
- 7933 Views
- I also Faced
- E-Mail Answers
Answer Posted / siri reddy
Inorder to select first n number of rows fetch is used in
conjunction with select statement
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is bind package and plan in db2?
What is the use of db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to create db2 table in mainframe?
What is buffer pool?
How to find the number of rows in a db2 table?
What is sqlca’s maximum length?
What is a plan and package in db2?
Define declaration generator (dclgen).
Which command is used to remove all rows from a table?
How do I import data from excel to db2?
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 ?...
Name the various locking levels available?
What os does db2 run on?
Differentiate between cs and rr isolation levels? Where do you specify them?
