order loan late1 late2 type 11111 2222 1 0 CL 11111 3333 4 1 CL 33333 4444 5 2 PL 33333 5555 6 3 PL 44444 6666 8 4 ML 55555 7777 9 3 MLI have tried this :
select order,type,sum(late1) as late1x,sum(late2) as late2x from mytable group by order,type;it is not working in order to get :
order late1x late2x type 11111 5 1 CL 33333 11 5 PL 44444 8 4 ML 55555 9 3 MLThank you in advance.