Sybase Error – Grouped query contains more than one distinct aggregate function

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.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error No plan. HTML_PLAN function is not supported for this...
In this blog post, you’ll learn more about the Sybase Error Division by zero and the reason for receiving this...
In this blog post, you’ll learn more about the Sybase Error Incorrect or missing encryption key and the reason for...