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

Is schema the same as database?

1062

How is the value function used?

1158

How do you select a row using indexes in db2?

1141

What is explain plan in db2?

1006

What is db2 command?

1043

How to compare data between two tables in db2?

1090

What are db2 objects?

1053

What is null value in db2?

1032

What are the full forms of spufi and dclgen and why are they used?

1094

What is cursor with hold option in db2?

1084

What is the difference between oracle and db2?

1117

What os does db2 run on?

994

What type of database is db2?

973

What do you mean by storage group (stogroup)?

1043

Highlight all the advantages that are attached to a package.

1121