Use built-in functions and GROUP BY in Transact-SQL
Learn how to use functions in Transact-SQL, and how to group aggregated results.
Learning objectives
After completing this module, you will be able to:
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
Prerequisites
Before starting this module, you should have experience of using Transact-SQL SELECT queries to retrieve data from tables in a database.