SQL Tips and Tricks

Re:SQL Tips and Tricks by alex5207 on Wednesday September 25, 2024 @01:37AM (#41644009)

Never knew about QUALIFY. That's great

[ Parent | on HN ]

Re:SQL Tips and Tricks by leosanchez on Wednesday September 25, 2024 @02:01AM (#41644135)

Looks like neither Postgres not SQL Server support QUALIFY

[ Parent | on HN ]

Re:SQL Tips and Tricks by FoeNyx on Wednesday September 25, 2024 @03:24AM (#41644612)

It was sadly hinted as a recent or non standard feature by Github's syntax highlighting not recognizing it either

[ Parent | on HN ]

Re:SQL Tips and Tricks by jabagawee on Wednesday September 25, 2024 @02:47AM (#41644400)

As I understand it, it's not part of the SQL standard.

[ Parent | on HN ]

Re:SQL Tips and Tricks by mr_toad on Wednesday September 25, 2024 @11:08PM (#41654158)

Snowflake, Databricks & Terradata support it, it’s very useful in data warehouses.

[ Parent | on HN ]