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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Write a multiple-column subquery.

Definition

Writing a multiple-column subquery should include a subquery written in the FROM clause.  Syntax clause should include the following commands:

SELECT column1, column2, column3,
FROM table
WHERE (column1, column2, column3) IN
SELECT column1, column2, column3
FROM tablename
WHERE condition;

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