9 Replies Latest reply: Jul 23, 2009 2:38 PM by Nitin Varshney RSS

how to use the SQL group by functionality on internal table.

Nitin Varshney
Currently Being Moderated

hi..

 

can any body explain me to how to use the SQL group by functionality on internal table.

 

i want to use the aggregate function on internal table using the different columns of the table.

 

like

 

in SQL we use

 

select werks matnr maktx extwg lgort umren meins sum(menge) sum(prd_wat)

from   itab

group by werks matnr maktx extwg lgort umren meins

 

how this functionality will work on internal table ?

 

similarly if i want to use the max, min or average of internal table column.

 

i just give you the sql statement above.

 

also just give me the some different ways to do this work.....

 

Regards

Nitin Varshney

Actions