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 are the rules for db2 programming?

1083

List down the data types in the db2 database.

1117

What is nvl in db2?

1089

Outputs of explain are with matchcols = 0. What does this signify?

1051

What is a bind in db2?

1039

How do I add a column in db2?

1048

What is ibm db2 used for?

1075

How do I copy a table in db2?

996

Define buffer pool.

1049

What is the difference between oracle and db2?

1100

What does db2 mean?

1013

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2178

What is a db2 schema?

1223

Is db2 a mainframe?

1041

What is precompiler in db2?

1012