| gajju |
Posted: Jun 25, 2009 02:42:19 AM |
Total Post: 3
Joined: Jun, 2009
|
what are the differnt between subquery and correlated subquery tell me in easily way?
|
|
|
RAJNISH |
| Posted: Jun 29, 2009 03:29:09 AM | |
|
Total Post: 137
Joined: Jan, 2007
|
Sub Query :- inner query return scalar(Single)value to outer query.
Co-Orelated Query:- Inner Query taking the Referanse of outer query in join.
Any Doubt u can ask.
|
|
|
|
|
Lucky |
| Posted: Jul 04, 2009 09:45:34 AM | |
|
Total Post: 13
Joined: Jun, 2009
|
Subqueries are of two types namely independent subquery and corelated subquery.
>Independent subqueries are those subqueries in which child subquery and parent query are independent of each other.
>corelated subquery are those subquery in which both parent subquery and child subquery are dependent on each other.And both the queries are executed in partial manner.
>Independent subquery is further divided into two types namely single row subquery and multiple row subquery.
>In single row subquery the child query returns only one record whereas in multiple row subquery the child query returns two or more records to the parent query.
I hope your doubt will be cleared if not please ask.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |