SQL Functions

SQL provides no. of inbuilt functions which perform calculations on groups of rows and return one value for the whole group.

Commonly used SQL functions:

1. SQL AVG(): It is used to get the average value of a numeric column.
Syntax:

SELECT AVG(columnName) FROM tableName;

2. SQL COUNT(): It is used to get the number of rows that matches specified criteria.
Syntax:

SELECT COUNT(columnName) FROM tableName;

3. SQL FIRST(): It is used to get the first value of the selected column.
Syntax:

SELECT FIRST(columnName) FROM tableName;

4. SQL LAST(): It is used to get the last value of the selected column.
Syntax:

SELECT LAST(columnName) FROM tableName;

5. SQL MAX(): It is used to get the largest value of the selected column.
Syntax:

SELECT MAX(columnName) FROM tableName;

6. SQL MIN(): It is used to get the smallest value of the selected column.
Syntax:

SELECT MIN(columnName) FROM tableName;

7. SQL SUM(): It is used to get the total sum of a numeric column.
Syntax:

SELECT SUM(columnName) FROM tableName;