"Grouped query contains more than one distinct aggregate function"
| Item |
Description |
|
SQLCode
|
-863L
|
|
Constant
|
INVALID_DISTINCT_AGGREGATE
|
|
SQLState
|
42W70
|
|
ODBC 2 State
|
37000
|
|
ODBC 3 State
|
42000
|
|
Sybase Error Code
|
2512
|
|
Severity Code
|
15
|
Probable cause
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.