Sunday, March 8, 2015

SQL: SUM() Aggregate Function

The SUM() function is used to sum up all the values in the specified column.

SELECT SUM(UnitsInStock) AS TotalInventory
FROM Products

The above query gets the total number of units in stock for all products

Posted by at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)