mysql SUM() function
Translation results:
英[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() functionsyntax
Function: Return the total number (total amount) of the numerical column.
Syntax: SELECT SUM(column_name) FROM table_name
mysql SUM() functionexample
//查找 "OrderPrice" 字段的总数 SELECT SUM(OrderPrice) AS OrderTotal FROM Orders;