7.25 Sort specification list

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

• ORDER BY clause

  See 4.5.1 Specification format and rules for the SELECT statement.

• A WITHIN group specification

  See 7.23.12 PERCENTILE_CONT, 7.23.13 PERCENTILE_DISC, and 7.23.14 LISTAGG.

• window-order-clause

  See 7.24.1 Specification format for window functions.

• ARRAY_AGG set function

  See 7.23.15 ARRAY_AGG.

Organization of this section

• 7.25.1 Specification format for the sort specification list

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

• 7.25.3 Rules for specifying a sort specification list in other than an ORDER BY clause

• 7.25.4 Examples

To Page Top