Title: Construct a single-row subquery.
Course: Database Design and Management (Oracle) (10052) > Section: Applying Advanced Data Selection Techniques

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.