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 control the max size of a heap table? : Sql dba

700


What are stored procedures used for?

725


What does select count (*) mean in sql?

733


what is 'mysqldump'? : Sql dba

757


what is 'mysqlimport'? : Sql dba

721






What problem one might face while writing log information to a data-base table in pl/sql?

757


Why is theta join required?

832


What is dense_rank?

694


What is right join sql?

707


What is a rank in sql?

712


what is the difference between sql and t-sql? : Transact sql

803


What does (*) mean in sql?

711


What is multiple columns?

770


What is java sql package?

732


How do I view output in sql developer?

802