What is a SQL Function and how to use a function in a T-SQL statement? We use the GetDate() and LEFT() functions as examples.
How to use the COUNT, MAX, AVG, and SUM Aggregate Functions in a T-SQL statement.
How to work with NULL values in Aggregate Functions in a T-SQL statement. How to fix issues with NULL values with the AVG() and COUNT() functions.
In this post, we discuss how to use the GROUP BY and HAVING clause in a T-SQL statement and how to use them with aggregate functions.