The Employee table of the AdventureWorks2012 database includes information on each employee's accrued vacation hours. When an employee takes a vacation and uses all his or her hours, the hours are reset to NULL. You want to determine the total number of employees who have a job title like Design Engineer who have outstanding vacation hours.

Which of the following T-SQL statements can you use to accomplish this task?

Posted by Rajkatie on 11/30/2012 | Category: Sql Server Interview questions | Views: 3759 | Points: 40

Select from following answers:

SELECT COUNT(VacationHours) FROM Employee WHERE JobTitle LIKE 'Design Engineer%';
SELECT SUM(VacationHours) FROM Employee WHERE JobTitle LIKE 'Design Engineer%';
SELECT AVG(VacationHours) FROM Employee WHERE JobTitle LIKE 'Design Engineer%';
All Above

Show Correct Answer

Source: Microsoft Press | | Alert Moderator

Bookmark It

< Previous : You want to use the appropriate function to conver ...

Next > : You want to remove the Odometer column of the Hove ...

More Interview Questions by Rajkatie

Latest Interview Questions