COUNT Function in SQL Server

COUNT( ) Function in SQL Server

DotNetKida-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)

Post a Comment

1 Comments