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

Answer Posted / ganesh

sub query is select statement which is lying in clause of
another sql stament


corelated subquery:

it is row-by-row processing, in which outer sub query is
processing for every inner query result

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you modify a column in sql?

530


What is a schema? How is it useful in sql servers?

589


what is datawarehouse? : Sql dba

565


What is dml statement?

515


how to start mysql server? : Sql dba

609






Is vs as in pl sql?

487


What is cte?

568


What does data normalization mean?

525


What is a sql statement?

527


What do you understand by pl/sql cursors?

546


What are the types of optimization?

519


Can you do multiple joins in sql?

543


Differentiate between pl/sql and sql?

613


What is cold data?

498


Can you inner join the same table?

523