SQLite Aggregate functions are the functions where values of multiple rows are grouped together as input on certain criteria and form a single value as output. Following is a list of some SQLite Aggregate function:
| Index | Function | Description |
|---|---|---|
| 1) | SQLite MIN Function | The SQLite MIN function is used to select the lowest (minimum) value for a certain column. |
| 2) | SQLite MAX Function | The SQLite MAX function is used to select the highest (maximum) value for a certain column. |
| 3) | SQLite AVG Function | The SQLite AVG function is used to select the average value for certain table column. |
| 4) | SQLite COUNT Function | The SQLite COUNT function is used to count the number of rows in a database table. |
| 5) | SQLite SUM Function | The SQLite SUM function is used to select the total for a numeric column. |
| 6) | SQLite RANDOM Function | The SQLite RANDOM function returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807. |
| 7) | SQLite ABS Function | The SQLite ABS function is used to get the absolute value of the numeric argument. |
| 8) | SQLite UPPER Function | The SQLite UPPER function is used to convert a string into upper-case letters. |
| 9) | SQLite LOWER Function | The SQLite LOWER function is used to convert a string into lower-case letters. |
| 10) | SQLite LENGTH Function | The SQLite LENGTH function is used to get the length of a string. |
| 11) | SQLite sqlite_version Function | The SQLite sqlite_version function is used to fetch the version of the SQLite library. |
