Count « Aggregate Functions « SQL Server / T-SQL






1.COUNT() function returns an integer value for the number of non-null values in the column range.
2.The COUNT(*) function ignores NULL values
3.Use 'count()' to count row number
4.Count with group by
5.Count distinct values
6.Count(*) from a table