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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Sort data by using ResultSet with the ORDER BY clause.

Definition

Demonstration of the ORDER BY clause should include the following sorting or querying strategies performed on a given set of data:

  • Ascending—will cause the result set to be ordered from smallest to largest
  • Descending—is typically the default order, from largest to smallest
  • Multiple columns—will produce sorting among results of a particular type
  • Column alias—is an alternate name assigned to a column to prevent query conflicts

Note: ORDER BY is always the last clause, because it rearranges the final ResultSet after all selection criteria is executed.

Related Standards of Learning

Mathematics

COM.7

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

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.150] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 4

[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.