XQuery - avg Function



The avg function is used to get the average of total items present in a sequence.

Syntax

avg($seq as item()*)

Input Parameters

  • $seq − provided sequence. A sequence can contain 0 or more items.

Example

XQuery Expression

let $items := (1,2,3,4,5,6)
let $avg := avg($items)
return
   <result>
      <avg>{$avg}</avg>     
   </result>

Output

<result>
   <avg>3.5</avg>  
</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