QUALIFY

Was kann QUALIFY?

Mit QUALIFY kannst du direkt auf das Ergebnis einer analytischen Funktion filtern.

Beispiel

BIGQUERY – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

Beispiel

CLICKHOUSE – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

Beispiel

DUCKDB – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

Beispiel

EXASOL – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

Beispiel

ORACLE – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

QUALIFY ist in Postgres noch nicht verfügbar.

Aber es gibt einen Proof of Concept für Postgres.

keine Beispiele

Zusammenfassung für PostgreSQL-Beispiele zum Thema Filtering. Platzhalter-Text.

Beispiel

SNOWFLAKE – code

 select customer_key
      , order_date
      , total_price
   from orders
qualify row_number() over
       (partition by customer_key
        order by order_date desc) = 1

Zusammenfassung für Snowflake-Beispiele zum Thema Filtering. Platzhalter-Text.

Common outro für QUALIFY