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