AdventureWorks Database: Find number of unique titles that employees can hold

Last update on October 29 2022 10:29:04 (UTC/GMT +8 hours)

SQL Query - AdventureWorks: Exercise-90 with Solution

90. From the following table write a query in SQL to return the number of different titles that employees can hold.

Sample table: HumanResources.Employee

Sample Solution:

SELECT COUNT(DISTINCT jobTitle) as "Number of Jobtitles" 
FROM HumanResources.Employee;

Sample Output:

Number of Jobtitles|
-------------------+
                 67|

SQL AdventureWorks Editor:

Contribute your code and comments through Disqus.

Previous: Compute moving average of yearly sales for all sales territories.
Next: Find the total number of employees.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.

How to select date without time in SQL?

select convert(varchar(10), '2011-02-25 21:17:33.933', 120)

120 here tells the convert function that we pass the input date in the following format: yyyy-mm-dd hh:mi:ss.

Ref : https://bit.ly/3SSoTvQ