-8034: Order column must be number


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 Response:

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.