SQL Functions

SQL has many built-in functions to perform calculations on data.

Some of the functions are

• AVG () – Returns the average value

• COUNT () – Returns the number or rows

• FIRST () – Returns the first value

• LAST () – Returns the last value

• MAX () – Returns the largest value

• MIN () – Returns the smallest value

• SUM () – Returns the sum

• UCASE () – Converts a field to upper case

• LCASE () – Converts a field to lower case

• MID () – Extract characters from a text field

• LEN () – Returns the length of a text field

• ROUND () – Rounds a numeric field to the number of decimals specified

• NOW () – Returns the current system date

• FORMAT () – Formats how a field is to be displayed

Apart from these, you have many data functions which will be specified in references.