This section provides you with the core functions of the SQLite including aggregate functions, date & time functions, string functions, and math functions.
SQLite aggregate functions
| Name | Description |
| AVG | Returns the average value of non-null values in a group |
| COUNT | Return the total number of rows in a table. |
| MAX | Returns the maximum value of all values in a group. |
| MIN | Returns the minimum value of all values in a group. |
| SUM | Returns the sum of all non-null values in a column |
| GROUP_CONCAT | Concatenates non-null values in a column |
SQLite string functions
| Name | Description |
| SUBSTR | Extracts and returns a substring with a predefined length starting at a specified position in a source string |
| TRIM | Returns a copy of a string that has specified characters removed from the beginning and the end of a string. |
| LTRIM | Returns a copy of a string that has specified characters removed from the beginning of a string. |
| RTRIM | Returns a copy of a string that has specified characters removed from the end of a string. |
| LENGTH | Returns the number of characters in a string or the number of byte in a BLOB. |
| REPLACE | Return a copy of a string with each instance of a substring replaced by the other substring. |
| UPPER | Returns a copy of a string with all of the characters converted to uppercase. |
| LOWER | Returns a copy of a string with all of the characters converted to lowercase. |
| INSTR | Finds a substring in a string and returns an integer indicating the position of the first occurrence of the substring. |
SQLite control flow functions
| Name | Description |
| COALESCE | Returns the first non-null argument |
| IFNULL | Provides the NULL if/else construct |
| NULLIF | Returns NULL if the first argument is equal to the second argument. |
SQlite date and time functions
| Name | Description |
| DATE | Calculates the date based on multiple date modifiers. |
| TIME | Calculates the time based on multiple date modifiers. |
| DATETIME | Calculates the date & time based on one or more date modifiers. |
| JULIANDAY | Returns the Julian day, which is the number of days since noon in Greenwich on November 24, 4714 B.C. |
| STRFTIME | Formats the date based on a specified format string. |
SQLite math functions
| Name | Description |
| ABS | Returns the absolute value of a number |
| RANDOM | Returns a random floating-point value between the minimum and maximum integer values |
| ROUND | Round off a floating value to a specified precision. |