5 ms·Never knew about QUALIFY. That's greatby alex5207 2y agoNever knew about QUALIFY. That's greatleosanchez 2y agoLooks like neither Postgres not SQL Server support QUALIFYjabagawee 2y agoAs I understand it, it's not part of the SQL standard.FoeNyx 2y agoIt was sadly hinted as a recent or non standard feature by Github's syntax highlighting not recognizing it eithermr_toad 2y agoSnowflake, Databricks & Terradata support it, it’s very useful in data warehouses.