Describe the different types of subqueries and correlated queries. Provide at least two examples.© BrainMass Inc. brainmass.com October 10, 2019, 4:50 am ad1c9bdddf
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 ...
Subqueries and correlated queries are described.