O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

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

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

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

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