question

  • Thread starter Thread starter inemuu
  • Start date Start date
I

inemuu

Suppose that I want the number of male employees in each deptment
rather than all employees. Can I specify this querry on SQL? why or why
not?
 
Without field and table names, we can only suggest something like:

SELECT Deptment, Count(*) as NumOf
FROM tblNoNameGiven
WHERE Gender="Male"
GROUP BY Deptment;
 
Back
Top