vendredi 8 mai 2015

sum of same year and same Id query

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