any example for select statement with group by clause

[Former Member]

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]

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]

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]

Hi Sarath

Thanks for ur reply.

It is not showing radio buttons to award points.

Kaki

[RichHeilman]

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

Regards,

Rich Heilman

[Former Member]

Ok Rich,

I wll do that.

Thanks

Kaki