W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
3.44.2
SQLite
392
C Interface
52
C Interface: Session Module
1
CLI
2
Database File Format
2
Datatypes
1
Dynamic Memory Allocation
1
Foreign Key Constraints
2
Full-Text Search
13
Geopoly
1
How To Corrupt
1
JSON
149
Language
1
Limits
1
Locking and Concurrency
152
Miscellaneous
1
PRAGMA Statements
11
Query Planner
1
R*Tree Module
1
RBU Extension
72
Syntax Diagrams
SQLite Syntax: aggregate-function-invocation
SQLite Syntax: alter-table-stmt
SQLite Syntax: analyze-stmt
SQLite Syntax: attach-stmt
SQLite Syntax: begin-stmt
SQLite Syntax: column-constraint
SQLite Syntax: column-def
SQLite Syntax: column-name-list
SQLite Syntax: comment-syntax
SQLite Syntax: commit-stmt
SQLite Syntax: common-table-expression
SQLite Syntax: compound-operator
SQLite Syntax: compound-select-stmt
SQLite Syntax: conflict-clause
SQLite Syntax: create-index-stmt
SQLite Syntax: create-table-stmt
SQLite Syntax: create-trigger-stmt
SQLite Syntax: create-view-stmt
SQLite Syntax: create-virtual-table-stmt
SQLite Syntax: cte-table-name
SQLite Syntax: delete-stmt
SQLite Syntax: delete-stmt-limited
SQLite Syntax: detach-stmt
SQLite Syntax: drop-index-stmt
SQLite Syntax: drop-table-stmt
SQLite Syntax: drop-trigger-stmt
SQLite Syntax: drop-view-stmt
SQLite Syntax: expr
SQLite Syntax: factored-select-stmt
SQLite Syntax: filter-clause
SQLite Syntax: foreign-key-clause
SQLite Syntax: frame-spec
SQLite Syntax: function-arguments
SQLite Syntax: indexed-column
SQLite Syntax: insert-stmt
SQLite Syntax: join-clause
SQLite Syntax: join-constraint
SQLite Syntax: join-operator
SQLite Syntax: literal-value
SQLite Syntax: numeric-literal
SQLite Syntax: ordering-term
SQLite Syntax: over-clause
SQLite Syntax: pragma-stmt
SQLite Syntax: pragma-value
SQLite Syntax: qualified-table-name
SQLite Syntax: raise-function
SQLite Syntax: recursive-cte
SQLite Syntax: reindex-stmt
SQLite Syntax: release-stmt
SQLite Syntax: result-column
Show more… (22)
1
Tcl Interface
2
Virtual Table Mechanism
11
Write-Ahead Logging
frame-spec
GROUPS
BETWEEN
UNBOUNDED
PRECEDING
AND
UNBOUNDED
FOLLOWING
RANGE
ROWS
UNBOUNDED
PRECEDING
expr
PRECEDING
CURRENT
ROW
expr
PRECEDING
CURRENT
ROW
expr
FOLLOWING
expr
PRECEDING
CURRENT
ROW
expr
FOLLOWING
EXCLUDE
CURRENT
ROW
EXCLUDE
GROUP
EXCLUDE
TIES
EXCLUDE
NO
OTHERS
Used by:
over-clause
window-defn
References:
expr
See also:
lang_aggfunc.html
lang_altertable.html
lang_attach.html
lang_createindex.html
lang_createtable.html
lang_createtrigger.html
lang_createview.html
lang_delete.html
lang_expr.html
lang_insert.html
lang_returning.html
lang_select.html
lang_update.html
lang_upsert.html
lang_with.html
partialindex.html
SQLite is in the Public Domain.
https://sqlite.org/syntax/frame-spec.html