15.00 - 3554 HAVING clause must be preceded by GROUP BY clause. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3554 HAVING clause must be preceded by GROUP BY clause.

Explanation:

The user cannot use a HAVING clause without a corresponding GROUP BY clause. The HAVING clause selects the values that the GROUP BY clause uses.

Generated By:

OPT modules.

For Whom:

End User.

Remedy:

Correct SELECT statement and resubmit request.