Recursive Queries and the HAVING Clause - Advanced SQL Engine - Teradata Database

HAVING cannot be specified in a recursive statement of a recursive query. However, a nonrecursive seed statement in a recursive query can specify the HAVING clause.