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 Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....