topic any example for select statement with group by clause in Application Development and Automation Discussions

any example for select statement with group by clause

Former Member — Sun, 30 Oct 2005 13:38:19 GMT

Hi experts,

Could any one give me the good example of select statement with group by clause(for ex:BSAK table).

reward guaranteed..

Kaki

Former Member — Sun, 30 Oct 2005 14:28:44 GMT

lets consider we have 3 fields in an database table :

MATNR, WERKS, KMENG.

Values are : 100, 1000, 50.00

100, 1001, 80.00

100, 1001, 60.00

101, 1005, 100.00.

Now i can use group by to get the average of quantities (MENGE) for a given material and plant.

Select MATNR WERKS AVG (MENGE)

into itab

from dtab

group by MATNR.

So itab contents are : 100, 1000, 50.00

100, 1001, 70.00

101, 1005, 100.00

Hope it was useful.

Former Member — Sun, 30 Oct 2005 14:36:33 GMT

Hi Sarath

Thanks for ur reply.

It is not showing radio buttons to award points.

Kaki

RichHeilman — Mon, 31 Oct 2005 02:09:06 GMT

Reward points system is currently down. Please come back later and try to reward the helpful answer. Thanks.

Regards,

Rich Heilman

Former Member — Mon, 31 Oct 2005 03:03:01 GMT

Ok Rich,

I wll do that.

Thanks

Kaki