The sum function is used to get the sum of total items present in a sequence.
Syntax
sum($seq as item()*)
Input Parameters
- $seq − provided sequence. Sequence can contain 0 or more items.
Example
XQuery Expression
let $items := (1,2,3,4,5,6) let $sum := sum($items) return <result> <sum>{$sum}</sum> </result>
Output
<result> <sum>21</sum> </result>
Verify the Result
In order to test the above-mentioned functionality, replace the contents of books.xqy (mentioned in Environment Setup chapter) with the above XQuery expression and execute the XQueryTester java program to verify the result.
Pingback: XQuery - Sequence Functions - Adglob Infosystem Pvt Ltd