Subqueries and correlated queries

Solution Preview

Welcome to BrainMass.com! Please rate 5/5 for my notes and ideas.
Thank you so much for using BrainMass!

Primarily there are two types of subqueries 1) single-row and 2)multiple-row subqueries.
The single-row subquery returns only one row for the given query. There is a scenario in single row subquery, where the query returns with one column. This type of query is called a scalar subquery. This type of query is useful when you are processing using a constant or an expreseesion or a ...