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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
