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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Demonstrate the syntax for select statements (projection).

Definition

Demonstration should include the proficient use of a working syntax, based on the instructor’s objectives and guidelines, and might include some of the following:
  • Minimum required clauses of SELECT and FROM
  • SELECT statement to project all columns using “*”
  • SELECT statement to project specific columns
  • SELECT statement including the WHERE clause and one comparison operator to create a selection
  • SELECT statement using the keyword DISTINCT to retrieve a list of unique values

Related Standards of Learning

Mathematics

COM.14

The student will select and implement appropriate data structures, including arrays (one- and/or two-dimensional) and objects.

Other Related Standards

NBEA Achievement Standards for Information Technology

Enter data and edit fields and records.