sql count rows in table

SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.