• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 468
  • Last Modified:

SQL Count function

I need to come up with Syntax to find the number of employees (Employee.Emp_ID) in each classification EEO1_Classification
0
Winstink
Asked:
Winstink
2 Solutions
 
Roman GhermanSenior Software EngineerCommented:
Hi,
Could you give more details?

---------------
Find me on: http://extremedev.blogspot.com
0
 
Shaun KlineLead Software EngineerCommented:
Select EEO1_Classification, count(*)
from Employee
group by EEO1_Classification
0
 
käµfm³d 👽Commented:
It sounds like you need a GROUP BY:
SELECT EEO1_Classification, COUNT(1) As Count
FROM Employee
GROUP BY EEO1_Classification

Open in new window

0
 
käµfm³d 👽Commented:
Awww shucks Shaun_Kline....  you beat me to it  = )
0
 
mmr159Commented:
One gets points for speed, one for form. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now