In this blog post, let’s learn about the error message “4120 In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the ORDER BY clause must be one of the columns explicitly SELECTed by the query. Column in error: name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4120 In a query with a GROUP BY, DISTINCT, or aggregate function, each column in the ORDER BY clause must be one of the columns explicitly SELECTed by the query. Column in error: name.
Reason for the Error
You attempted to perform a query with an aggregate function, a GROUP BY clause, or a DISTINCT clause. A column in the ORDER BY clause, name, is not one of the columns explicitly selected by the query.
Solution
Correct the ORDER BY clause and resubmit
