Database Analyst Question: Download Database Analyst PDF
Tell us what are the different types of subqueries?
Answer:
There are two types of subqueries: correlated and uncorrelated.
An uncorrelated subquery is a independent query whose output is substituted into the main query. A correlated subquery, on the other hand, uses values from the outer query and therefore depends on the outer query. Such a subquery executes repeatedly, once for each row that is selected by the outer query.
An uncorrelated subquery is a independent query whose output is substituted into the main query. A correlated subquery, on the other hand, uses values from the outer query and therefore depends on the outer query. Such a subquery executes repeatedly, once for each row that is selected by the outer query.
| Previous Question | Next Question |
| Please explain what are aggregate functions? | As you said you have just been assigned a new analytics project. Where do you begin and what are the steps that follow? |