Summary

  • 3 minutes

In this module, you learned how to:

  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with the GROUP BY clause
  • Filter groups with the HAVING clause

Here is a video tutorial accompanying this training module to enhance your learning experience.

For more detailed information about Transact-SQL syntax, refer to the Transact-SQL reference documentation.