COUNT

COUNT

--========================================== [COUNT]=======================================================================

--COUNT aggregate function is used to count the number of rows in a database table.

--Count--

SELECT COUNT(LastName) AS NumberOfContacts

FROM Person.Contact