XQuery while using distinct-values()

Question

XML File ``` ``` I am using following XQuery - ``` for $x in doc("sample")/Cities/Place/City order by $x/@n return distinct-values($x/@n) ``` The result I am expecting is - `Chandigarh Mumbai New Delhi` but getting - `Chandigarh Chandigarh Mumbai Mumbai New Delhi New Delhi New Delhi` Please tell me where am I going wrong?

Accepted Answer

pls try this -

```
for $x in distinct-values(doc("sample")/Cities/Place/City/@n)
   order by $x
   return $x
```

I have checked the same with baseX 7.1 and working smoothly as expected by you :)

XQuery while using distinct-values()

Solution

Problem