SQL Functions

SQL functions return a single value.

SQL Scalar functions:

SQL scalar functions return based on the input value.

• FORMAT() -- Formats how a field is to be displayed
• MID() -- Extract characters from a string
• LEN() -- Returns the length of a string
• UCASE() -- Converts a string to upper case
• LCASE() -- Converts a string to lower case
• ROUND() -- Rounds a numeric field to the number of decimals specified
• NOW() -- Returns the current system date and time

SQL Aggregate Functions:

SQL aggregate functions return a value calculated from values in a column.

•  FIRST() - Returns the first value
•  LAST() - Returns the last value
•  MAX() - Returns the largest value
•  MIN() - Returns the smallest value
•  AVG() - Returns the average value
•  COUNT() - Returns the number of rows
•  SUM() - Returns the sum