XQuery - sum Function


Advertisements

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.

xquery_sequence_functions.htm
Advertisements