Skip to content

Commit 03bc6b9

Browse files
committed
[DOCS] Document support for the SQL QUALIFY clause
1 parent ca35538 commit 03bc6b9

File tree

1 file changed

+4
-0
lines changed

1 file changed

+4
-0
lines changed

docs.feldera.com/docs/sql/grammar.md

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -352,6 +352,7 @@ select
352352
[ WHERE booleanExpression ]
353353
[ GROUP BY [ ALL | DISTINCT ] { groupItem [, groupItem ]* } ]
354354
[ HAVING booleanExpression ]
355+
[ QUALIFY booleanExpression ]
355356
```
356357

357358
<a id="lateral"></a>
@@ -586,6 +587,9 @@ Currently we require window ranges to have constant values. This
586587
precludes ranges such as `INTERVAL 1 YEAR`, which have variable sizes.
587588
The window bounds must be non-negative constant values.
588589

590+
The `QUALIFY` clause is applicable only to window aggregates, and it
591+
filters the result produced by the window aggregate.
592+
589593
## Table functions
590594

591595
Table functions are invoked using the syntax `TABLE(function(arguments))`.

0 commit comments

Comments
 (0)