SQL Functions Review
Last Updated: June 23, 2021 12:01:58 PM PDT
Give feedback
Use this guide to review SQL functions and how they work.
Note: If you don't know the SQL programming language, you can use QueryLink by clicking the Queries button in FinancialLink, EmployeeLink, Student/ Class Info tools, and DataLink.
| SQL Functions | Usage |
|---|---|
| Aggregate functions | Generate summary values |
| count | Counts the number of rows or rows with specific information in a table |
| avg | Calculates the average of the numeric values in a specified column |
| max | Determines the maximum value in a specified column |
| min | Determines the minimum value in a specified column |
| sum | Determines the sum of the numeric values in a specified column |
| String functions | Perform various operations on character strings or expressions |
| substring | Extracts a substring from a source string, the source string being either a character or bit string |
| upper | Converts a character string to all uppercase characters |
| lower | Converts a character string to all lowercase characters |
| trim | Trims off leading or trailing blanks or characters from a character string |
| convert | Takes a source datatype and converts it into another datatype |
For more information, contact the Data Warehouse team.