SQL has many built-in functions for performing different processing on various data. The Following is the list of some commonly used SQL functions:
The SQL AVG aggregate function selects the average value for certain table column.
NUMERIC. – The SQL COUNT aggregate function is used to count the number of rows in a database table.
STRING. – This is used to concatenate any string inside any SQL command.
The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
This is used to generate a random number using SQL command.
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.
- SQL Numeric Functions – List of SQL functions required to manipulate numbers in SQL.
- SQL String Functions – List of SQL functions required to manipulate strings in SQL.