Apache Derby DB Error Code 42878 – The ORDER BY clause of a SELECT UNION statement only support

Posted by AbundantCode

In this blog post, let’s learn about the error message “42878- The ORDER BY clause of a SELECT UNION statement only support” in Apache Derby Database and the description of the error.

Error Message

42878- The ORDER BY clause of a SELECT UNION statement only support

Error Details

The ORDER BY clause of a SELECT UNION statement only supports unqualified column references and column position numbers. Other expressions are not currently supported.