Teradata Database Message 3554 - 3554 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

Correct SELECT statement and resubmit request.