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