w3resource

AdventureWorks Database: Find the total number of employees

SQL Query - AdventureWorks: Exercise-91 with Solution

91. From the following table write a query in SQL to find the total number of employees.

Sample table: HumanResources.Employee


Click to view Full table

Sample Solution:

SELECT COUNT(*)  as "Number of Employees"
FROM HumanResources.Employee;

Sample Output:

Number of Employees|
-------------------+
                290|

SQL AdventureWorks Editor:

Practice Online


Contribute your code and comments through Disqus.

Previous: Find number of unique titles that employees can hold.
Next: Find average bonus for salespersons achieved quota above 25000.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.