SQLite Aggregate Functions
SQLite Aggregate functions are used to perform certain calculations on a numeric value, a string or the multiple rows of an SQLite table. Some of the SQLite Aggregate functions are:
| FUNCTION | USES |
| MIN | To select the lowest (minimum) value for a certain column. |
| MAX | To select the highest (maximum) value for a certain column. |
| AVG | To select the average value for certain table column. |
| COUNT | To count the number of rows in a database table. |
| SUM | To select the total for a numeric column. |
| RANDOM | To get a pseudo-random integer between -9223372036854775808 and +9223372036854775807. |
| ABS | To get the absolute value of the numeric argument. |
| UPPER | To convert a string into uppercase letters. |
| LOWER | To convert a string into lower-case letters. |
| LENGTH | To get the length of a string. |
| sqlite_version | To fetch the version of the SQLite library. |