O'Reilly logo

Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) by Gavin Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required