7.24 Sort specification list

This section describes the sort specification list. Sort specification lists are specified in the following locations:

• ORDER BY clause

  See 4.4.1 Specification format and rules for the SELECT statement.

• WITHIN group specification

  See 7.22.12 PERCENTILE_CONT and 7.22.13 PERCENTILE_DISC.

• Window order clause

  See 7.23.1 Specification format for window functions.

Organization of this section

• 7.24.1 Specification format for the sort specification list

• 7.24.2 Rules for specifying a sort specification list in an ORDER BY clause

• 7.24.3 Rules for specifying a sort specification list in a WITHIN group specification or window order clause

• 7.24.4 Examples

To Page Top