SQL: SUM() Aggregate Function
The SUM() function is used to sum up all the values in the specified column.
The above query gets the total number of units in stock for all products
SELECT SUM(UnitsInStock) AS TotalInventory
FROM Products
The above query gets the total number of units in stock for all products
Comments
Post a Comment