XQuery - avg Function

Xquery For Dummies: The Videocourse

18 Lectures 44 mins

Pedro Planas

More Detail

XQuery For Beginners: Learn The Basics

18 Lectures 42 mins

Pedro Planas

More Detail

XQuery; Learn The Basics

18 Lectures 47 mins

Pedro Planas

More Detail

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.