Documentation Source Text

Check-in [61483bc834]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Pre-expand key railroad diagrams in the windowfunctions.html page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 61483bc834c9ca72dd857fc0334f7565c1c871023b819f25849a06fa804f4aa3
User & Date: drh 2018-08-15 13:21:40.322
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
Side-by-Side Diff Ignore Whitespace Patch
Changes to pages/windowfunctions.in. 
1
2
3
4
5
6
7
8
9
10
11
12
13
14

15
16
17
18
19
20
21

1
2
3
4
5
6
7
8
9
10
11
12
13

14
15
16
17
18
19
20
21














-
+








<tcl>hd_keywords {window functions}</tcl>

<title>Window Functions</title>
<table_of_contents>

<h1>Introduction to Window Functions</h1>

<p>A window function is a special SQL function where the input
values are taken from
a "window" of one or more rows in the results set of a SELECT statement.


<tcl>
RecursiveBubbleDiagram window-function-invocation
RecursiveBubbleDiagram window-function-invocation window-defn frame-spec filter
</tcl>

<p>Window functions are distinguished from ordinary SQL functions by the
presence of an OVER clause.  If a function invocation has an OVER clause
then it is a window function, and if lacks a OVER clause it is an ordinary
function.  Window functions might also have a FILTER
clause in between the function and the OVER clause.
︙