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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct a multi-row subquery.

Definition

Construction should include subqueries that return more than one value, using the following multiple-row comparison operators and guidelines for their use:
  • IN—used when the outer query WHERE clause is designed to select only those rows that are equal to one of the list of values returned from the inner query
  • ANY—used when the outer query WHERE clause is designed to select the rows that are equal to, less than, or greater than at least one value in the subquery result set
  • ALL—used when the outer query WHERE clause is designed to select the rows that are equal to, less than, or greater than all values in the subquery result set
  • IN, ANY, ALL, and NOT—used in combination with standard comparison operators (+, >, <, >=, <=)

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