DB2 - Write a query to display the number of people working in dept. 100

Posted by Bandi on 11/30/2013 | Category: Others Interview questions | Views: 2023 | Points: 40

Answer:

SELECT COUNT(*) “COUNT OF EMPLOYEES IN 100TH DEPARTMENT”
FROM EMPLOYEES
WHERE DEPARTMENT_ID=100

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : DB2 - Display the average salaries of each DEPARTM ...

Next > : DB2 - Display the highest, lowest, sum, and averag ...

More Interview Questions by Bandi

Latest Interview Questions