Hacker News new | ask | show | jobs
by alex5207 628 days ago
Never knew about QUALIFY. That's great
1 comments

Looks like neither Postgres not SQL Server support QUALIFY
It was sadly hinted as a recent or non standard feature by Github's syntax highlighting not recognizing it either
As I understand it, it's not part of the SQL standard.
Snowflake, Databricks & Terradata support it, it’s very useful in data warehouses.