| title | url |
|---|---|
XPath sum |
/refguide7/xpath-sum/ |
The sum() function returns the sum of its argument.
The function requires an XPath query as argument.
The function must specify a column in the query to aggregate.
The query must specify an attribute that has a numeric type.
This query returns the sum of the total prices of all placed orders:
sum(//Sales.Order/TotalPrice)This query returns the sum of the total prices of all the orders placed by a customer named "Jansen":
sum(//Sales.Order[Sales.Customer_Order/Sales.Customer/Name = 'Jansen']/TotalPrice)