SQL Functions

SQL has many built-in functions for performing different processing on various data. The Following is the list of some commonly used SQL functions:

SQL AVG

The SQL AVG aggregate function selects the average value for certain table column.

SQL COUNT

NUMERIC. – The SQL COUNT aggregate function is used to count the number of rows in a database table.

SQL CONCAT

STRING. – This is used to concatenate any string inside any SQL command.

SQL MAX

The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.

SQL MIN

The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

SQL RAND

This is used to generate a random number using SQL command.

SQL SUM

NUMERIC. – The SQL SUM aggregate function allows selecting the total for a numeric column.

SQL SQRT Functions

NUMERIC. – This is used to generate a square root of a given number.

Additional Lists