In this blog post, you’ll learn more about the Sybase Error Grouped query contains more than one distinct aggregate function and the reason for receiving this error
Sybase SQL Error Message
Grouped query contains more than one distinct aggregate function
Reason for this Error
Two or more DISTINCT aggregate functions were specified in the same grouped query. This is only permitted if the Hash Group By operator is available. Any query block can only contain at most one DISTINCT aggregate function if the Hash Group By operator is not available.