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

• Rules for specifying a sort specification list in a WITHIN group specification or ARRAY_AGG set function

  1. Set functions are not permitted in a value expression specified as a sort key.

• Rules for specifying a sort specification list in a window order clause

  1. Set functions are not permitted in a value expression specified as a sort key.

  2. If you specify duplicate sort keys, the first order specification and null-value sort order specification takes precedence.

To Page Top