目录
- PostgreSQL Tutorial
- Database
-
PostgreSQL Syntax
- PostgreSQL Operators
- PostgreSQL SELECT
- PostgreSQL
- PostgreSQL WHERE
- PostgreSQL ORDER BY
- PostgreSQL LIMIT
- PostgreSQL MIN and MAX
- PostgreSQL COUNT
- PostgreSQL SUM
- PostgreSQL AVG
- PostgreSQL LIKE
- PostgreSQL IN
- PostgreSQL BETWEEN
- PostgreSQL AS
- PostgreSQL Joins
- PostgreSQL INNER JOIN
- PostgreSQL LEFT JOIN
- PostgreSQL RIGHT JOIN
- PostgreSQL FULL JOIN
- PostgreSQL CROSS JOIN
- PostgreSQL UNION
- PostgreSQL GROUP BY
- PostgreSQL HAVING
- PostgreSQL EXISTS
- PostgreSQL ANY
- PostgreSQL ALL
- PostgreSQL CASE
- Exercises
PostgreSQL SUM Function
SUM
The SUM() function returns the total sum of a numeric column.
The following SQL statement finds the sum of the quantity fields in the order_details table:
Example
Return the total amount of ordered items:
SELECT SUM(quantity)
FROM order_details;
Run Example »
Note: NULL values are ignored.
PostgreSQL Exercises
截取页面反馈部分，让我们更快修复内容！也可以直接跳过填写反馈内容!