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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Construct a single-row subquery.

Definition

Construction should include the following syntax:

SELECT column, column
FROM  [table name]
WHERE column >= (
SELECT column with compatible data type in the WHERE clause
FROM [table]
WHERE condition )

Note: Subqueries are complex queries that have a SELECT statement within a SELECT statement. The purpose of a subquery is to find the answer based on unknown criteria.

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