COUNT function 1

[krets]

I have a table of employees and in that table there is a field named "Function" that designates the employee as a pharmacist or technician. What my managers would like to do is be able to quickly view the ratio of pharmacists to technicians for board of pharmacy compliance purposes.

To count each one I've done:

SELECT COUNT (EmployeeId) FROM EmployeeTable WHERE Location = "Kansas" AND Function = "Pharmacist";

SELECT COUNT (EmployeeId) FROM EmployeeTable WHERE Location = "Kansas" AND Function = "Technician";

Is there a way to combine these into one query? Or possibly a better way to designate their job functions?

 

[HarleyQuinn]

How about:

SELECT Function, COUNT (EmployeeId) FROM EmployeeTable WHERE Location = "Kansas" GROUP BY Function;

That should give you a count for each function within the same query.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[krets]

Ahhh, perfect! Star for you!

 

[HarleyQuinn]

Glad I could help

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.