CodesJava

Easy learning with example program codes

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:

 

FUNCTIONUSES
MINTo select the lowest (minimum) value for a certain column.
MAXTo select the highest (maximum) value for a certain column.
AVGTo select the average value for certain table column.
COUNTTo count the number of rows in a database table.
SUMTo select the total for a numeric column.
RANDOMTo get a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
ABSTo get the absolute value of the numeric argument.
UPPERTo convert a string into uppercase letters.
LOWERTo convert a string into lower-case letters.
LENGTHTo get the length of a string.
sqlite_versionTo fetch the version of the SQLite library.

 

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status