← Back to list

Aggregation Filter in Oracle AI 26 ai

This post is quick one!

Zahir Mohideen · 2026-06-11 12:38 · 0 claps · 0.9 min read
#oracle-ai-database #new-features #sql #analytical-function #window-functions
Open on Medium ↗

Aggregation Filter in Oracle AI 26 ai

This post is quick one!

Aggregation filter is a neat addition to the SQL in Oracle AI 26ai ( 23.26.1).This feature makes SQL concise , easier to read.

Looks different . Probably , I have to get used to it . :-) . I welcome your thoughts on this feature.

Here is an example.

Here is the newer syntax.

Here is the equivalent syntax that we used to use in pre-26 releases of Oracle.

Originally published at https://zahirmohideen.blogspot.com/2026/02/aggregation-filter-in-oracle-ai-26-ai.html


메타데이터
post_id
41b29b374b08
slug
aggregation-filter-in-oracle-ai-26-ai-41b29b374b08
url
https://medium.com/@zahirmohideen/aggregation-filter-in-oracle-ai-26-ai-41b29b374b08
canonical_url
https://medium.com/@zahirmohideen/aggregation-filter-in-oracle-ai-26-ai-41b29b374b08
author_url
https://medium.com/@zahirmohideen
status
ok
fetched_at
2026-06-27 18:20:27