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 copy pending and check pending in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is check constraint in db2?
What is reorg and runstats in db2?
What is sqlca’s maximum length?
When reorg is used?
Explain about dbrm.
How to create db2 table in mainframe?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is consistency token in db2?
What is load replace in db2?
What is the use of predicate?
Explain packages.
What is runstats and reorg in db2?
What is db2 command?