What is correlated subquery?

Answer Posted / s

Correlated subquery refers to atleast one column of the
outer query. The correlated subquery is evaluated for each
qualifying row from the outer query.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is phantom read in db2?

652


Is db2 a mainframe?

599


Explain package in db2 and its advantages?

608


What parameters are used to control the free space in DB2?

651


What are concurrency issues?

636






What is host variable?

605


Can we update view in db2?

568


Explain various types of locks in db2?

707


What are the prerogatives?

629


How to check last update on table in db2?

636


How do I delete a table in db2?

655


What is copy pending and check pending in db2?

588


Which is faster delete or truncate?

689


How connect db2 database to datastage?

783


What is the use of db2 optimizer?

621