Background documentation-8034: Order column must be number Locate this document in the navigation structure

 

Explanation

In a QUERY statement with the outermost QUERY expression containing at least one UNION, INTERSECT or EXCEPT, the ORDER clause must not contain column specifications.

User Respone

Replace the column specifications with the corresponding numbers of the output columns or with the result column name (result_column_name) used in the first QUERY specification of the outer QUERY expression.