my table is :
Year Type Id Amt
2015-16 1 100
2015-16 1 50
2015-16 2 20
2016-17 2 100
2016-17 2 10
I need a result with sum of Amt depend upon group by 2 column year & typeId :
2015-16 1 150
2016-17 2 130
i can easily sum with single group by column but don't know how can i sum with multiple columns. please let me know if anyone know
Aucun commentaire:
Enregistrer un commentaire