SQL Functions
SQL has many built-in functions to perform calculations on data.
Some of the functions are
SQL Aggregate Functions
• 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
SQL Scalar Functions
• 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.