Sum Syntax:
SELECT SUM(column_name)
FROM table_name
Sales table:
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
Sum Example:
SELECT SUM(price) FROM store;
SELECT SUM(column_name)
FROM table_name
| ID | PRICE | NAME |
|---|---|---|
| 1 | 200 | A |
| 2 | 500 | B |
| 3 | 900 | C |
| 4 | 500 | D |
SELECT SUM(price) FROM store;