Mega Code Archive

 

Categories / XML / Xquery

 

Grouping in XQuery

File: Data.xml <!-- car order docuCt --> <order>   <car dept="A">     <number>1</number>     <name>name 1</name>   </car>   <car dept="B">     <number>2</number>     <name>name 2</name>   </car>   <car dept="B">     <number>3</number>     <name>name 3</name>   </car>   <car dept="C">     <number>4</number>     <name>name 4</name>   </car> </order> File: Query.xquery for $d in distinct-values(doc("Data.xml")//car/@dept) return    <result dept="{$d}"            count="{count(doc("Data.xml")//car[@dept = $d])}"/> Output: <?xml version="1.0" encoding="UTF-8"?> <result count="1" dept="A"/> <result count="2" dept="B"/> <result count="1" dept="C"/>