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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Restrict data, using the BETWEEN ... AND and IN clauses.

Definition

Demonstration should use the clauses in the following ways:

  • BETWEEN ... AND—to show an upper and lower limitation for results returned from the query
  • IN—to search for a match to a set of values and return only the matches

Related Standards of Learning

Mathematics

COM.7

The student will select and call library functions to process data, as appropriate.

COM.13

The student will implement various mechanisms for performing iteration with an algorithm

Other Related Standards

Microsoft Imagine Academy Resources

[3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2

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

[5.035] Access 2010: Project 3

NBEA Achievement Standards for Information Technology

Sort, prioritize, and retrieve data from databases.