Could anyone clearly explain the diference between sub
query and correlated sub query?
Answer Posted / praveen
if we want to select 100th hig no.
in sub-query we will write 100 conditions.
to avoid this we go for correlated sub-query
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a bind card?
Explain about cursor stability?
List out the three types of page locks that can be held.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do we specify index to include or not during bind process.
What is the difference between bind and rebind in db2?
What is bind package and plan in db2?
What is host variable in db2 cobol?
What is the difference between dbm cfg and db cfg file in db2 ?
What is db2 look?
What is scrollable cursor in db2?
What is the use of dclgen in db2?
What does db2 plan contain?