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
SELECT SUM(quantity)
FROM order_details;
Note: NULL values are ignored.
Want to go beyond the notes?
Join Coding Now Tech Institute's PostgreSQL course — live mentorship, real projects, and 100% placement support.
Enroll Now — Free Demo AvailablePostgreSQL SUM – FAQs
Quick answers about learning PostgreSQL SUM in PostgreSQL.
This free note from Coding Now Tech Institute explains PostgreSQL SUM in PostgreSQL — concept, syntax and worked code examples you can copy, run and revise before interviews.
Yes. Every PostgreSQL topic on Coding Now Tech Institute, including PostgreSQL SUM, is 100% free with no signup required.
With focused practice, most students grasp PostgreSQL SUM in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.
Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.