# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 599976213

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct a correlated subquery.

Definition

Constructing a correlated subquery requires that the inner query execute once for each result returned in the parent query. A correlated subquery will have a JOIN from inner to outer query.

Related Standards of Learning

Mathematics

COM.9

The student will implement pre-defined algorithms, including sort routines, search routines, and simple animation routines.

Other Related Standards

Microsoft Imagine Academy Resources

[3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1

[4.019] Access 2010: Modify Database Tables—Lesson 3

[5.037] Access 2010: Project 5