topic Re: select and count from table in Application Development and Automation Discussions

select and count from table

Former Member — Mon, 24 Mar 2008 15:43:34 GMT

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

Re: select and count from table

Former Member — Mon, 24 Mar 2008 15:47:46 GMT

Can you do the following:

Select project count(*) as cnt
from zmytable
group by project

Re: select and count from table

Former Member — Mon, 24 Mar 2008 15:58:40 GMT

Hi jerry

i do like u tell and i get just the project in itab the pernr Colman is empty what i miss?

regards

Re: select and count from table

Former Member — Mon, 24 Mar 2008 16:04:54 GMT

That's hard to say. Why don't you select project and pernr without the count and group by, and examine the data?

Re: select and count from table

former_member194669 — Mon, 24 Mar 2008 16:05:56 GMT

Keep you internal table like this way


data : begin of itab occurs 0.
 data : project like zmytable-project.
 data : cnt   type i.
data : end of itab.

Select project count(*) as cnt
from zmytable
into table itab
group by project.

a®

Re: select and count from table

Former Member — Tue, 25 May 2010 09:10:43 GMT

Thanks