XQuery distinct-values Function

How to use the XQuery distinct-values function to extract unique items from a sequence, with syntax and practical examples.

The distinct-values function is used to get the sequence containing unique items present in a given sequence.

Syntax

distinct-values($seq as item()*)

Input Parameters

$seq is the provided sequence. A sequence can contain 0 or more items.

Example

XQuery Expressionxquery

let $items := (1,2,4,4,5,5)
let $unique-items := distinct-values($items)
return
   <result>
      <items>
      {
         for $item in $unique-items
         return <item>{$item}</item>
      }
      </items>
   </result>

Outputxml

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