COUNT(*)

 

3> select COUNT(*) from sales;

COUNT(*) returns the total count of all records (rows) in the column, including NULL values of selected records by the query. : Count « Aggregate Functions « SQL Server / T-SQL Tutorial