SQL Language Expressions

sqlite.org

Tin mới

function-arguments:

common-table-expression:

compound-operator:

table-or-subquery:

sqlite3_bind_parameter_index()

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

database connection

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

SQLITE_LIMIT_VARIABLE_NUMBER

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

iif(x,y,z) SQL function

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

sqlite3_snprintf()

Casting an INTEGER or REAL value into TEXT renders the value as if via sqlite3_snprintf() except that the resulting TEXT uses the encoding of the database connection.

date-time functions

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

sqlite3_create_function()

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):

simple-function-invocation:

aggregate-function-invocation:

window-function-invocation:

aggregate functions

SQLite understands these operators, listed in precedence1 order (top to bottom / highest to lowest):