add window frame clause
-----------------------
Key: CORE-3647
URL: http://tracker.firebirdsql.org/browse/CORE-3647
Project: Firebird Core
Issue Type: Sub-task
Components: Engine
Reporter: Philippe Makowski
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
