SQLite Aggregate Function

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:

SQLite MIN Function
SQLite MAX Function
SQLite AVG Function
SQLite COUNT Function
SQLite SUM Function
SQLite RANDOM Function
SQLite ABS Function
SQLite UPPER Function
SQLite LOWER Function
SQLite LENGTH Function
SQLite sqlite_version 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.