XQuery subsequence Function

Use the XQuery subsequence() function to extract a specific range of items from a sequence by specifying a starting position and length.

The subsequence function is used to get the sequence containing requested items present in a given sequence.

Syntax

subsequence($seq as item()*, $startingLoc as xs:double, $length as xs:double)

Input Parameters

$seq is the provided sequence. A sequence can contain 0 or more items.
$startingLoc is the index of items from which sub-sequence is to be created. Index starts from 1.
$length is the length of subsequence.

Example

XQuery Expressionxquery

let $items := (1,2,3,4,5,6)
let $sub-items := subsequence($items,2,4)
return
   <result>   
      <items>
      {
         for $item in $sub-items
         return <item>{$item}</item>
      }
      </items>
   </result>

Outputxml

<result>
   <items>
      <item>2</item>
      <item>3</item>
      <item>4</item>
      <item>5</item>
   </items>
</result>