if we want to select 100th hig no. in sub-query we will write 100 conditio

Could anyone clearly explain the diference between sub
query and correlated sub query?

Question Posted / praveen

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

Please Help Members By Posting Answers For Below Questions

What is multi row fetch in db2?

1101

What is the meaning concurrency in the db2 database?

1161

What is universal database?

1118

What is dbrm in db2 database?

1191

What is the difference between using bind () and rebind () methods of naming class?

1455

How to find the number of rows in db2 tables?

1127

What is the difference between cursor stability and repeatable read isolation levels?

1237

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3203

What is the max length of sqlca?

1268

How can you quickly find out the # of rows updated after an update statement?

1084

What does reorg do in db2?

1074

What are iseries servers?

1131

can we view the access paths created by dbrm ? how ? thx

7200

What are types of indexes?

1187

List out the buffer pools in db2

1128