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;

Popular Recommendations

Home

Videos

Q&A