4 ms·

QUALIFY is not part of the SQL standard.

• gigatexal 3y ago
  Then a subselect with the window function and an outer where clause where the window function column = 1
• da_chicken 3y ago
  I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it.
  • orlp 3y ago
    I don't know, and I don't feel like paying $200 per chapter to find out.
  • riku_iki 3y ago
    more importantly you can run prql on Postgres today, but can't use qualify yet