O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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

Images

4

Restricting and Sorting Data

CERTIFICATION OBJECTIVES

4.01     Sort the Rows That Are Retrieved by a Query

4.02     Limit the Rows That Are Retrieved by a Query

4.03     Use Ampersand Substitution to Restrict and Sort Output at Run Time

4.04     Use the SQL Row Limiting Clause

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter looks at various capabilities of the SELECT statement: the WHERE clause, the ORDER BY clause, ampersand substitution, and the SQL row limiting clause. The ORDER BY clause sorts the retrieved rows. It’s very flexible: it can sort rows in ascending or descending order, or it can sort by expression lists or take ...

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