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