W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
3.30.1
SQLite
354
C Interface
48
C Interface: Session Module
19
CLI
46
Database File Format
20
Datatypes
14
Dynamic Memory Allocation
7
Foreign Key Constraints
93
Full-Text Search
13
Geopoly
9
How To Corrupt
20
JSON
175
Language
12
Limits
6
Locking and Concurrency
170
Miscellaneous
146
PRAGMA Statements
35
Query Planner
8
R*Tree Module
7
RBU Extension
69
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: 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
SQLite Syntax: rollback-stmt
Show more… (19)
80
Tcl Interface
49
Virtual Table Mechanism
23
Write-Ahead Logging
expr
Used by:
aggregate-function-invocation
attach-stmt
column-constraint
compound-select-stmt
create-index-stmt
create-trigger-stmt
delete-stmt
delete-stmt-limited
factored-select-stmt
filter-clause
frame-spec
indexed-column
insert-stmt
join-constraint
ordering-term
over-clause
result-column
select-core
select-stmt
simple-function-invocation
simple-select-stmt
table-constraint
table-or-subquery
update-stmt
update-stmt-limited
upsert-clause
window-defn
window-function-invocation
References:
filter-clause
literal-value
over-clause
raise-function
select-stmt
type-name
See also:
lang_UPSERT.html
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_select.html
lang_update.html
lang_with.html
partialindex.html
SQLite is in the Public Domain.
https://sqlite.org/syntax/expr.html