Use built-in functions and GROUP BY in Transact-SQL

Beginner
Data Analyst
Data Engineer
Data Scientist
Database Administrator
Developer
Solution Architect
Student
Technology Manager
SQL Database
SQL Server
SQL Managed Instance
SQL Server on Virtual Machines
SQL Server on Azure Virtual Machines

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.