Background documentation-1013: Too many order columns Locate this document in the navigation structure

 

Explanation

The following causes of errors are possible:

  1. More than 128 columns were specified as sort criterion or group columns.

  2. The total length of the order or group columns exceeds 1020 bytes.

  3. The length of the longest result data type of a DISTINCT function, together with the lengths of the group columns, exceeds 254 characters. The result data type is the data type which is assigned to the result of an expression.

User Response

In the SQL statement, you must remove one or more columns specified in the ORDER clause or GROUP clause.