Sub query means A query within another query. the Sub query executed first

diff b/w sub query and co-relater query?

Question Posted / guru

3 Answers
10994 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / guru

Sub query means A query within another query. the Sub query
executed first and returns result, which is used by Main Query.

Correlated Sub query:

The sub query has a Reference with a value or values of Main
Query, Which is Called as COrrelated Sub Query.

Thanks

Guru

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is natural join same as inner join?

984

how to show all tables with 'mysql'? : Sql dba

1158

What program will open a mdb file?

1020

Can we rollback after truncate?

1072

What is string join?

1025

is it possible to pass an object or table to a procedure as an argument?

1178

what is subquery? : Sql dba

1190

How sql query is executed?

1187

Explain how exception handling is done in advance pl/sql?

1046

What is sql performance tuning?

980

What are the different ddl commands in sql?

1251

what is commit? : Sql dba

1124

What is sql*loader and what is it used for?

1219

What is keys and its types?

1121

What is data control language (dcl)?

1205