SQL SUM
SQL SUM
The SQL SUM function returns the sum value of all rows in a select query.
SUM syntax
SELECT SUM(table_column) FROM table_name;
SUM example
Coder books table
| ID | Title | Price | Description | 
|---|---|---|---|
| 1 | Learn SQL | 20 | Learn SQL language | 
| 2 | Learn MySQL | 22 | Learn MySQL language | 
| 3 | HTML book | 17 | Learn HTML | 
| 4 | Learn PHP | 20 | Introduction to PHP | 
| 5 | Learn PHP | 20 | PHP course | 
SELECT SUM(price) FROM coder_books;
Result
99
SELECT price, SUM(price) sum_price FROM coder_books GROUP BY price HAVING count(*) > 1;
Result
| Price | sum_price | 
|---|---|
| 20 | 60 |