MS SQL

MS SQL RSS

problems with sum...

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Apr 2009

Posts: 2

Reputation: almis is an unknown quantity at this point

Solved Threads: 0

almis

Offline

Newbie Poster

problems with sum...

Apr 3rd, 2009

Hi!

I have this table:

id table #people
1 ...1 .........3
2 ...1 .........5
3 ...4 .........2
4 ...3 .........5
5 ...1......... 2

i want to obtain the sum of people sitting per table.

hope you can help me...

•

Join Date: May 2007

Posts: 4,438

Reputation: Ezzaral has much to be proud of

Solved Threads: 510

Ezzaral

Offline

Industrious Poster

Re: problems with sum...

Apr 3rd, 2009

So you would just need to "group by" table and use another aggregate function to sum them up. I bet you can find that function pretty easily.

•

Join Date: May 2007

Posts: 146

Reputation: Stylish is an unknown quantity at this point

Solved Threads: 14

Stylish

Offline

Junior Poster

Re: problems with sum...

Apr 3rd, 2009

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT TABLE, sum(people)
FROM TABLES
GROUP BY TABLE
SELECT table, sum(people)
FROM Tables
GROUP BY table

All aggregate functions (sum, max, min, avg, etc) must include a GROUP BY including all columns up-to the aggregate.

If this is a school assignment, I suggest you crack the books and spend time in the lab.

Last edited by Stylish; Apr 3rd, 2009 at 4:13 pm.

I NEED AN ADULT!