| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: Difference between nested query,sub query and nested query?
Answer: what is difference between nested query,sub query and nested query? explain clearly with an example? |
| September 09, 2008 14:53:21 |
#1 |
| arpitapatel |
Member Since: September 2008 Total Comments: 1 |
RE: Difference between nested query,sub query and nested query?
|
query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query.
Nested subquery runs only once for the entire nesting (outer) query. It does not contain any reference to the outer query row.
|
| |
Back To Question | |
