In this blog post, let’s learn about the error message “4015 Aggregate functions are placed incorrectly:name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4015 Aggregate functions are placed incorrectly:name.
Reason for the Error
You used aggregate function name on an ungrouped table. For example, you used an aggregate function in a predicate (WHERE or HAVING), but the aggregated columns come from the local scope instead of an outer scope.
Solution
Correct the syntax and resubmit
