Use of Group by and aggregate function on given table

Feb 22 2021 7:42 PM

I have a below table

ContainerNumber Orgzn PO_Gross

------------------------------------------------------------------------------------------

MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 40

SZLU9006949 [ZL]Zestfruit (Pty) Ltd 30

MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 10

SZLU9006949 [ZL]Zestfruit (Pty) Ltd 50

TTNU8324679 [ZL]Zestfruit (Pty) Ltd 70

--------------------------------------------------------------------------------------------

Need Output in below format.

--------------------------------------------------------------------------------------------

ContainerNumber Orgzn PO_Gross

-------------------------------------------------------------------------------------------

MNBU3319850 [AZ]Komati Fruits (Pty) Ltd 50

SZLU9006949 [ZL]Zestfruit (Pty) Ltd 80

TTNU8324679 [ZL]Zestfruit (Pty) Ltd 70

Answers (2)

how to return xml while using webservice?