We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Submitted by: @pmakowski
Jira_subtask_inward CORE1688
Votes: 7
frame clause is useful, especially for first_value,last_value, and nth_value| that consider only the rows within the "window frame"
syntax : <window frame clause> ::= <window frame units> <window frame extent> [ <window frame exclusion> ]
<window frame units> ::= ROWS | RANGE
<window frame extent> ::= <window frame start> | <window frame between>
<window frame start> ::= UNBOUNDED PRECEDING | <window frame preceding> | CURRENT ROW
<window frame preceding> ::= <unsigned value specification> PRECEDING
<window frame between> ::= BETWEEN <window frame bound 1> AND <window frame bound 2>
<window frame bound 1> ::= <window frame bound>
<window frame bound 2> ::= <window frame bound>
<window frame bound> ::= <window frame start> | UNBOUNDED FOLLOWING | <window frame following>
<window frame following> ::= <unsigned value specification> FOLLOWING
<window frame exclusion> ::= EXCLUDE CURRENT ROW | EXCLUDE GROUP | EXCLUDE TIES | EXCLUDE NO OTHERS
Commits: f80d135 41d24de
The text was updated successfully, but these errors were encountered:
assignee: Adriano dos Santos Fernandes [ asfernandes ]
Sorry, something went wrong.
Commented by: @asfernandes
Spliting <window frame exclusion> in another ticket.
summary: add window frame clause => Window Function: frame (rows / range) clause
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 4.0 Alpha 1 [ 10731 ]
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: Done successfully
status: Resolved [ 5 ] => Closed [ 6 ]
asfernandes
No branches or pull requests
Submitted by: @pmakowski
Jira_subtask_inward CORE1688
Votes: 7
frame clause is useful, especially for first_value,last_value, and nth_value| that consider only the
rows within the "window frame"
syntax :
<window frame clause> ::=
<window frame units> <window frame extent>
[ <window frame exclusion> ]
<window frame units> ::=
ROWS
| RANGE
<window frame extent> ::=
<window frame start>
| <window frame between>
<window frame start> ::=
UNBOUNDED PRECEDING
| <window frame preceding>
| CURRENT ROW
<window frame preceding> ::=
<unsigned value specification> PRECEDING
<window frame between> ::=
BETWEEN <window frame bound 1> AND <window frame bound 2>
<window frame bound 1> ::=
<window frame bound>
<window frame bound 2> ::=
<window frame bound>
<window frame bound> ::=
<window frame start>
| UNBOUNDED FOLLOWING
| <window frame following>
<window frame following> ::=
<unsigned value specification> FOLLOWING
<window frame exclusion> ::=
EXCLUDE CURRENT ROW
| EXCLUDE GROUP
| EXCLUDE TIES
| EXCLUDE NO OTHERS
Commits: f80d135 41d24de
The text was updated successfully, but these errors were encountered: