Go to SQLite built-in function table

SQLite built-in function table

Arithmetic functions
ABS (X)	Returns the absolute value of a given numeric expression.
Max (X, Y [,...])	Returns the maximum value of an expression.
Min (X, Y [,...])	Returns the minimum value of an expression.
Random (*)	Returns a random number.
Round (X [, y])	Returns a numeric expression rounded to the specified length or precision.
Character Processing functions
Length (X)	Returns the number of characters in a given string expression.
Lower (X)	Converts uppercase data to lowercase data and returns a character expression.
Upper (X)	Returns a string expression that converts lowercase data to uppercase.
Substr (x, y, z)	Return part of the expression.
Randstr ()
Quote ()
Like (A, B)	Determines whether the specified string matches the specified pattern.
Glob (A, B)
Conditional judgment Function
Coalesce (X, Y [,...])
Ifnull (x, y)
Nullif (x, y)
Set Functions
AVG (X)	Returns the average value of the group's values.
Count (X)	The number of items in the returned group.
Max (X)	Returns the maximum value of a group.
Min (X)	Returns the minimum value of the group value.
Sum (X)	Returns the sum of all values in the expression.
Other functions
Typeof (X)	Type of the returned data.
Last_insert_rowid ()	Returns the ID of the last inserted data.
Sqlite_version (*)	Returns the SQLite version.
Change_count ()	Returns the number of rows affected by the previous statement.
Last_statement_change_count ()