SQLite - Date & Time

SQLite - C/C++

SQLite has many built-in functions to perform processing on string or numeric data. Following is the list of few useful SQLite built-in functions and all are case in-sensitive which means you can use these functions either in lower-case form or in upper-case or in mixed form. For more details, you can check official documentation for SQLite.

Sr.No.	Function & Description
1	SQLite COUNT Function SQLite COUNT aggregate function is used to count the number of rows in a database table.
2	SQLite MAX Function SQLite MAX aggregate function allows us to select the highest (maximum) value for a certain column.
3	SQLite MIN Function SQLite MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
4	SQLite AVG Function SQLite AVG aggregate function selects the average value for certain table column.
5	SQLite SUM Function SQLite SUM aggregate function allows selecting the total for a numeric column.
6	SQLite RANDOM Function SQLite RANDOM function returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
7	SQLite ABS Function SQLite ABS function returns the absolute value of the numeric argument.
8	SQLite UPPER Function SQLite UPPER function converts a string into upper-case letters.
9	SQLite LOWER Function SQLite LOWER function converts a string into lower-case letters.
10	SQLite LENGTH Function SQLite LENGTH function returns the length of a string.
11	SQLite sqlite_version Function SQLite sqlite_version function returns the version of the SQLite library.

Before we start giving examples on the above-mentioned functions, consider COMPANY table with the following records.

ID          NAME        AGE         ADDRESS     SALARY
----------  ----------  ----------  ----------  ----------
1           Paul        32          California  20000.0
2           Allen       25          Texas       15000.0
3           Teddy       23          Norway      20000.0
4           Mark        25          Rich-Mond   65000.0
5           David       27          Texas       85000.0
6           Kim         22          South-Hall  45000.0
7           James       24          Houston     10000.0

SQLite COUNT Function

SQLite COUNT aggregate function is used to count the number of rows in a database table. Following is an example −

sqlite> SELECT count(*) FROM COMPANY;