Functions in SQL enable you to perform feats such as determining the sum of a column or converting all the characters of a string to
These functions are also referred to as group functions. They return a value based on
the values in a column.
The function COUNT returns the number of rows that satisfy the condition in the WHERE
SUM returns the sum of all values in a column.
The AVG function computes the average of a column.
If you want to find the largest value in a column, use MAX.
MIN returns the lowest member of a column.
VARIANCE produces the square of the standard deviation,
Date and Time Functions
This function adds a number of months to a specified date.
LAST_DAY returns the last day of a specified month.
To know how many months fall between month x and month y.
Many of the uses you have for the data you retrieve involve mathematics.
The ABS function returns the absolute value of the number you point to.
Many implementations of SQL provide functions to manipulate characters and strings of
These three conversion functions provide a handy way of converting one type of data to