abhijit dhanwate

abhijit dhanwate

  • 1.9k
  • 80
  • 580

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)