How to find sum of all row in mysql query - mysql count the sum of all rows
I have a mysql table that has a number of rows, and in each row a field called "value", the field value will differ from row to row. What I want, is to select all the rows and count the sum of all the "value" fields.
+-----------+------------+---------------+--------+
| ProductID | SaleDate | PaymentMethod | Amount |
+-----------+------------+---------------+--------+
| 3 | 2012-02-10 | Cash | 10 |
| 3 | 2012-02-10 | Cash | 10 |
| 3 | 2012-02-10 | Check | 15 |
| 3 | 2012-02-10 | Credit Card | 25 |
| 4 | 2012-02-10 | Cash | 5 |
| 4 | 2012-02-10 | Check | 6 |
| 4 | 2012-02-10 | Credit Card | 7 |
+-----------+------------+---------------+--------+
How to find sum of all row in mysql query , mysql count the sum of all rows , MySQL - sum column value(s) based on row from the same table
Mysql
- asked 9 years ago
- Sandy Hook
2Answer
Do you mean like this?
SELECT SUM(value)
FROM myTable
If you have multiple columns to return, simply add each non-aggregate (i.e., summed) row to the GROUP BY clause:
SELECT firstName, lastName, SUM(value)
FROM myTable
GROUP BY firstName, lastName
- answered 8 years ago
- B Butts
Do you mean like this?
SELECT SUM(value)
FROM myTable
If you have multiple columns to return, simply add each non-aggregate (i.e., summed) row to the GROUP BY clause:
SELECT firstName, lastName, SUM(value)
FROM myTable
GROUP BY firstName, lastName
- answered 8 years ago
- B Butts
Your Answer