XQuery - Sequence Functions

Advertisements

The following table lists the commonly used sequence functions provided by XQuery.

Sr.No	Name & Description
1	count($seq as item()*) Counts the items in a sequence.
2	sum($seq as item()*) Returns the sum of the items in a sequence.
3	avg($seq as item()*) Returns the average of the items in a sequence.
4	min($seq as item()*) Returns the minimum valued item in a sequence.
5	max($seq as item()*) Returns the maximum valued item in a sequence.
6	distinct-values($seq as item()*) Returns select distinct items from a sequence.
7	subsequence($seq as item()*, $startingLoc as xs:double, $length as xs:double) Returns a subset of provided sequence.
8	insert-before($seq as item(), $position as xs:integer, $inserts as item()) Inserts an item in a sequence.
9	remove($seq as item()*, $position as xs:integer) Removes an item from a sequence.
10	reverse($seq as item()*) Returns the reversed sequence.
11	index-of($seq as anyAtomicType()*, $target as anyAtomicType()) Returns indexes as integers to indicate availability of an item within a sequence.
12	last() Returns the last element of a sequence when used in predicate expression.
13	position() Used in FLOWR expressions to get the position of an item in a sequence.