Applies the aggregate function to all values. ALL is the default.
An expression of any type except uniqueidentifier, image, or ntext. Aggregate functions and subqueries are not permitted.
Specifies that all rows should be counted to return the total number of rows in a table. COUNT(*) takes no parameters. COUNT(*) does not require an expression parameter because, by definition, it does not use information about any particular column. COUNT(*) returns the number of rows in a specified table without eliminating duplicates. It counts each row separately, including rows that contain NULL values.