How can I add up values in a SQL column? I have the table set up in xampp and I'm trying to add up all the values in a column titled "gross".
- Thanks for the quick responses! I've got it working and now have a follow-up question. Is there a way to add up only positive numbers in the column and then add up only negative numbers in the column. Thankscmorris1441– cmorris14412012-02-17 20:15:01 +00:00Commented Feb 17, 2012 at 20:15
- Updated my answer accordinglyBrian Webster– Brian Webster2012-02-17 20:19:38 +00:00Commented Feb 17, 2012 at 20:19
Add a comment |
3 Answers
SQL Server or MySQL:
select sum(MyColumn) as MyColumnSum from MyTable If you need to sum a column by a grouping of another column
select sum(MyColumn) as MyColumnSum, OtherColumn from MyTable Group By OtherColumn Here is a way to, separately, add up negative or positive numbers
select sum( case when MyColumn < 0 then MyColumn else 0 end ) as NegativeSum, sum( case when MyColumn > 0 then MyColumn else 0 end ) as PositiveSum from MyTable Reference
1 Comment
bfavaretto
Since he mentions xampp, it's MySQL, but the query should work.
Take a look at the SUM() function documentation for MySQL.
SELECT YourRecordID, SUM(Gross) AS GrossSum FROM YourTable GROUP BY YourRecordID 