mysql SUM() function

英[sʌm] 美[sʌm]

n.Amount; total; arithmetic; outline, key points

vt.& vi.Summary; total; summary, summary

Third person singular: sums Plural: sums Present participle: summing Past tense: summed Past participle: summed

mysql SUM() function syntax

Function: Return the total number (total amount) of the numerical column.

Syntax: SELECT SUM(column_name) FROM table_name

mysql SUM() function example

//查找 "OrderPrice" 字段的总数
SELECT SUM(OrderPrice) AS OrderTotal FROM Orders;