COUNT( ) Function in SQL Server

COUNT() is a function that takes the name of a column as an parameter and return the number of rows where column is not null.

SELECT COUNT(COLUMN_NAME)

FROM TABLE_NAME

[ NOTE: Usage of COUNT in SQL full detailed post ]

Let's learn use of COUNT() function in SQL Server with an example 

(Example : How To Count the no. of members in distinct department)

Also Read: How to use COUNT in SQL