question

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?
 
D

Duane Hookom

Without field and table names, we can only suggest something like:

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