sql table how to adding array of numbers fetched from sql table

Question

In a sql table how to adding array of numbers fetched from sql table

Table like 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 the table How to add a array Money without USA.

I want the addition money from table without USA

$Totalmoney=2010+130+110+1450;

sql coding fetching without USA Rows then how to add those money values without USA

SELECT Id,country,Person,Money  
FROM Customers   
WHERE country !="USA";

what is your expected output..your question is not clear?

Amit Singh
– Amit Singh

2013-07-19 10:45:43 +00:00
Commented Jul 19, 2013 at 10:45 — Amit Singh
– Amit Singh, Commented Jul 19, 2013 at 10:45

valex · Accepted Answer · 2013-07-19 10:56:27Z

1

SELECT sum(Money)
FROM Customers   
WHERE country !="USA";

answered Jul 19, 2013 at 10:56

valex

24.2k7 gold badges47 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DevZer0 · Accepted Answer · 2013-07-19 10:42:34Z

1

very simple use the not equal operator !=

SELECT ID,country,Person,money  
FROM Customers   
WHERE country != "USA";

answered Jul 19, 2013 at 10:42

DevZer0

13.5k7 gold badges29 silver badges54 bronze badges

Comments

kevinm · Accepted Answer · 2013-07-19 10:59:00Z

1

SELECT SUM(Money)
FROM Customers   
WHERE country !="USA";

answered Jul 19, 2013 at 10:59

kevinm

4752 silver badges8 bronze badges

Collectives™ on Stack Overflow

sql table how to adding array of numbers fetched from sql table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related