Question & Additional Information
 
what is the difference between a correlated subquery and an independent sudquery?
Add to My IQ
 

Answer Title
Answer
The  correlated subquery is not completed before the outer query is executed. The inner query references the outer query.
Question Tag Title
Tags
Question Asked At Title
Asked At
None
Question Job Title
Job Titles


Check out our newest job listings!

Post a Job! $49 for 60 days



Your Name:
Add your comment text
 
Related Questions
Related Questions
Flag this interview question as inappropriate Inappropriate
See Answer
Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed once for the parent query or it can be executed once for each row returned by the parent query. If the subquery is executed for each row of the parent, this is called a correlated subquery.

A correlated subquery can be easily identified if it contains any references to the parent subquery columns in its WHERE clause. Columns from the subquery cannot be referenced anywhere else in the parent query. The following example demonstrates a non-correlated subquery.
Create Date
:
Tuesday, May 13, 2008
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
A query that contains a correlated subquery.
Create Date
:
Wednesday, April 02, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer

 

 

Create Date
:
Monday, September 24, 2007
Tags
:
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (2) :
1.
dk123
Wednesday, March 19, 2008 6:27 AM
nice comment
2.
thingMaster
Tuesday, October 23, 2007 1:52 PM
you are overconfident. you will probably kill many patients, but drive a nice car.
Flag this interview question as inappropriate Inappropriate
See Answer
If your images are inside a table, be sure to set the BORDER, CELLSPACING, and CELLPADDING attributes to 0.
Extra space between images is often created by whitespace around the <IMG> tag in the markup. It is safe to use newlines inside a tag (between attributes), but not between two tags.
Create Date
:
Tuesday, September 18, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
 
• More Related Questions: 
Suggestions & Comments




Share Your Interview Questions
Ask Interview Questions
View Unanswered Questions





Advertise on this site