Select NUMCMDE,NUMLIGNE,SUM(temp)
from table
group by NUMCMDE,NUMLIGNE