Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Pre-expand key railroad diagrams in the windowfunctions.html page. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
61483bc834c9ca72dd857fc0334f7565 |
| User & Date: | drh 2018-08-15 13:21:40 |
Context
|
2018-08-25
| ||
| 14:56 | Fix a duplicate fragment name in lang_expr.html check-in: 8ffd68dac7 user: drh tags: trunk | |
|
2018-08-15
| ||
| 13:21 | Pre-expand key railroad diagrams in the windowfunctions.html page. check-in: 61483bc834 user: drh tags: trunk | |
|
2018-08-08
| ||
| 17:36 | Fixes to the CGI handling in althttpd.c. check-in: 6faf1e47b9 user: drh tags: trunk | |
Changes
Changes to pages/windowfunctions.in.
7 7 8 8 <p>A window function is a special SQL function where the input 9 9 values are taken from 10 10 a "window" of one or more rows in the results set of a SELECT statement. 11 11 12 12 13 13 <tcl> 14 -RecursiveBubbleDiagram window-function-invocation 14 +RecursiveBubbleDiagram window-function-invocation window-defn frame-spec filter 15 15 </tcl> 16 16 17 17 <p>Window functions are distinguished from ordinary SQL functions by the 18 18 presence of an OVER clause. If a function invocation has an OVER clause 19 19 then it is a window function, and if lacks a OVER clause it is an ordinary 20 20 function. Window functions might also have a FILTER 21 21 clause in between the function and the OVER clause.