O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT 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

6

Sorting Rows

In this chapter:

  • How are rows in queries sorted both manually and automatically?

  • How are null values affected when sorting rows?

  • What are the types of sorting methods for the ORDER BY clause?

This chapter extends the syntax of the SELECT statement by examining ORDER BY clause sorting and the various detailed aspects of SELECT statement ORDER BY clauses.

6.1 ORDER BY Clause Syntax

Previous chapters have examined the SELECT, FROM, and WHERE clauses. This chapter adds the ORDER BY clause to the SELECT statement. Here is a quick description of each clause:

  • SELECT. List all the columns you want to see in your report here. Separate them with commas. Use an asterisk (*) instead of a list of columns to automatically show all columns ...

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