Aggregate Function Basics « Aggregate Functions « SQL Server / T-SQL






1.Null value is eliminated by an aggregate or other SET operation
2.Use sum function in a table join