Skip to Content
0
Former Member
Mar 24, 2008 at 03:43 PM

select and count from table

29 Views

Hi,

I have table with project end pernr and i wont to count how much

employee i have for projects

e.g.

pernr        project

123         e0-111
565         e0-111
158         e0-111
145         e1-222
456         e1-222
665         e1-222
222         e1-222
222         e6-777

i wont to get:

e0-111 3

e1-222 4

e6-777 1

What is the best way to do that ?

Regards