In this post, you’ll learn about the error message -127 distinct is specified more than once in a subselect in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-127 distinct is specified more than once in a subselect
Reason for the Error
The DISTINCT qualifier can be used only once in a SELECT statement or a subselect.
Solution
The implied function is not supported by DB2.
