Chapter 3. Filtering (WHERE) and Sorting Data (ORDER BY)

Terms You Need to Understand

  • ✓ The WHERE clause

  • ✓ The ORDER BY clause

  • ✓ Filtering

  • ✓ Sorting

  • ✓ Comparison condition

  • ✓ Logical condition

  • ✓ Top-N query

  • ✓ Ascending sort

  • ✓ Descending sort

Concepts You Need to Master

  • ✓ Filtered queries

  • ✓ Sorted queries

  • ✓ Precedence of logical conditions

  • ✓ What the available comparison conditions are

  • ✓ What the available logical conditions are

  • ✓ Comparison conditions compare expressions

  • ✓ Logical conditions allow for multiple comparisons

  • ✓ What equi, anti, and range comparison conditions are

  • ✓ The use of LIKE, IN, EXISTS, BETWEEN, ANY, SOME, and ALL comparison conditions

  • ✓ Logical condition precedence: (), NOT, AND, OR

  • NULL values and sorting

  • ✓ Sorting methods

This chapter covers ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.