topic Re: select count problem in Application Development and Automation Discussions

select count problem

Former Member — Wed, 10 Jan 2007 08:54:30 GMT

Hallow I doing a select statement for count but its not write I have a error what I doing wrong in this select

<b>SELECT orgeh COUNT( * ) AS orgeh

FROM pa0001

INTO TABLE count_itab

GROUP BY orgeh</b>

WHERE ( persg EQ '6' OR persg EQ '7' OR persg EQ '8' )

AND stell = 'A'

AND orgeh NE '00009999'

AND orgeh = 'Z'.

regards

Re: select count problem

jayanthi_jayaraman — Wed, 10 Jan 2007 08:58:40 GMT

Hi,

Try this code and kindly reward points by clicking the star on the left of reply,if it helps.

data : begin of count_itab,

orgeh type pa0001-orgeh,

count type i,

end of count_itab.

SELECT orgeh COUNT( * )

FROM pa0001

INTO TABLE count_itab

WHERE ( persg EQ '6' OR persg EQ '7' OR persg EQ '8' )

AND stell = 'A'

AND orgeh NE '00009999'

AND orgeh = 'Z'

GROUP BY orgeh.

Re: select count problem

Former Member — Wed, 10 Jan 2007 09:01:36 GMT

Hi,

Try this

SELECT orgeh COUNT( * ) 
FROM pa0001
INTO TABLE count_itab
WHERE  persg IN ( '6' , '7' , '8'  )
AND stell = 'A'
AND orgeh NE '00009999'
AND orgeh = 'Z'
GROUP BY orgeh.

Y u have specified two conditions for a single field?

AND orgeh NE '00009999'

AND orgeh = 'Z'

Re: select count problem

Former Member — Wed, 10 Jan 2007 09:02:31 GMT

1) remove as Orgeh

2) use group by at end of ur where condition