Filter clause for aggregates in Oracle

• From: Saqib | Date: Wed, 22 Apr 2026 18:30:04 +0000 #
  Subject: Filter clause for aggregates in Oracle

  Oracle AI Database added the FILTER clause for aggregates in 23.26.1 Syntax: fn ( ... ) FILTER ( WHERE ... ) Example: SELECT u.buyer_id , tochar(u.joindate, 'yyyy-mm-dd') join_date , count(o.orderid) FILTER (WHERE tochar(o.orderdate, 'yyyy') = '2019') ordersin_2019 FROM users LEFT JOIN orders using (buyer_id) GROUP BY all ; Read more: https://www.oralenoir.com/conditional-filter-for-aggregates-in-oracle-database-26ai/

  [ Reply ]