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: 993 | Points: 40
Answer:

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


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response