Example
SELECT SUM(Quantity) AS TotalItemsOrdered FROM OrderDetails;Definition and Usage
The SUM() function calculates the sum of a set of values.
Note
NULL values are ignored.
Syntax
SUM(
expression
)Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. A field or a formula |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|