in sql table how adding array of numbers fetched sql table
table given below
id country person money 1 uk john 2010 2 usa henry 120 3 rus neko 130 4 ger suka 110 7 can beater 1450 8 usa lusi 2501 this table how add array money without usa.
i want addition money table without usa
$totalmoney=2010+130+110+1450;
sql coding fetching without usa rows how add money values without usa
select id,country,person,money customers country !="usa";
select sum(money) customers country !="usa";
Comments
Post a Comment