OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

5Restricting and Sorting Data

CERTIFICATION OBJECTIVES

5.01 Limit the Rows That Are Retrieved by a Query

5.02 Sort the Rows That Are Retrieved by a Query

Two-Minute Drill

Q&A Self Test

This chapter looks at two clauses of the SELECT statement: the WHERE clause and the ORDER BY clause. The WHERE clause specifies the criteria that are required for a row to be included in a SQL statement. Without it, all rows in a given table are retrieved, but with it, a SQL statement can selectively target particular rows for processing. The ORDER BY clause sorts the retrieved rows. It’s very flexible: it can sort rows in ascending or descending order, or it can ...