Aggregate Functions in SQLite

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.

 

Please Share