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


Please Help Members By Posting Answers For Below Questions

What is copy pending and check pending in db2?

664


How do you simulate the explain of an embedded sql statement in spufi/qmf?

724


What is check constraint in db2?

706


What is reorg and runstats in db2?

794


What is sqlca’s maximum length?

792






When reorg is used?

761


Explain about dbrm.

684


How to create db2 table in mainframe?

736


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1814


What is consistency token in db2?

749


What is load replace in db2?

641


What is the use of predicate?

675


Explain packages.

755


What is runstats and reorg in db2?

905


What is db2 command?

669