Count « Aggregate Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Aggregate Functions
  3. Count
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