sql query related !

Question

i have a table like below

name1	name2	amount1	amount2
aa	111	100	200
aa	111	200	300
aa	111	0	100
aa	111	250	350
bb	222	150	0
bb	222	300	400
cc	333	0	200
cc	333	350	0

here the name aa is repeated also 111 but the amounts are not repeated it is different

i want the repetative names as one record and the amount should be the sum

for eg i want the above table as the below table

name1	name2	amount1	amount2
aa	111	550	950
bb	222	450	400
cc	33	350	200

Sanwar Ranwa · Answer

CREATE TABLE ty(name1 VARCHAR (50),name2 VARCHAR (50) ,amount1 INT ,amount2 int ) SELECT * FROM ty t INSERT INTO ty values ( 'aa' , '111' ,100,200) INSERT INTO ty values ( 'aa' , '111' ,200,300) INSERT INTO ty values ( 'aa' , '111' ,0,200) INSERT INTO ty values ( 'aa' , '111' ,250,350) INSERT INTO ty values ( 'bb' , '222' ,150,0) INSERT INTO ty values ( 'bb' , '222' ,300,400) INSERT INTO ty values ( 'cc' , '333' ,0,200) INSERT INTO ty values ( 'cc' , '333' ,350,0) SELECT name1,name2 , Sum (amount1)amount1, Sum (amount2)amount1 FROM ty GROUP BY name1,name2 Subin try this its working

Navneet Arora · Answer

SELECT NAME1,NAME2 ,SUM(AMOUNT1) AS AMOUNT1 ,SUM(AMOUNT2) AS AMOUNT2 FROM TY GROUP BY NAME1,NAME2

Subin Thomas · Answer

im getting record as such name1 name2 amount1 amount2 aa 111 1350 1650 bb 222 1350 1650 cc 33 1350 1650

Madan Shekar · Answer

SELECT name1,name2, SUM (amount1)as firstamount, SUM (amount)as secondamount FROM orders GROUP BY name1,name2;

Sanwar Ranwa · Answer

Subin i update the query check now

Subin Thomas · Answer

no change still its giving 70 rows