3 ms·
Really varies by implementation. Snowflake supports it - https://docs.snowflake.com/en/sql-reference/constructs/having.html https://docs.snowflake.com/en/sql-r
by jameshart 5y ago
Really varies by implementation.
Snowflake supports it - https://docs.snowflake.com/en/sql-reference/constructs/having.html https://docs.snowflake.com/en/sql-reference/constructs/havin...
Redshift doesn’t: https://docs.aws.amazon.com/redshift/latest/dg/r_HAVING_clause.html https://docs.aws.amazon.com/redshift/latest/dg/r_HAVING_clau...
Databricks doesn’t: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-having.html https://docs.databricks.com/sql/language-manual/sql-ref-synt...
All of them do also support teradata’s QUALIFY clause which is like another layer over WHERE and HAVING that filters windowed data.