SQLServer COUNT()

SELECT COUNT(aggregate_expression)
FROM tables
[WHERE conditions]; 

SELECT COUNT(id)
FROM [lidihuo].[dbo].[Employees];

SELECT COUNT(*) AS "Number of Employees"
FROM Employee2
WHERE name = 'Rahul';