Explore BrainMass

Explore BrainMass

    Subqueries and correlated queries

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    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 ...

    Solution Summary

    Subqueries and correlated queries are described.