xQuery on returning maximum element



I am relatively new to xQuery. And I have been struggling to get a working solution for this. Basically i have the following xml:



<skills>
<skill name="xQuery" level="2"/>,
<skill name="R" level="1"/>,
<skill name="Python" level="4"/>,
<skill name="Python" level="5"/>,
<skill name="Java" level="2"/>,
<skill name="C" level="2"/>,
<skill name="C" level="5"/>
</skills>

My expected resut is:
<skill name="XQuery" level="2"/>,
<skill name="Python" level="5"/>,
<skill name="R" level="1"/>,
<skill name="Java" level="2"/>,
<skill name="C" level="5"/>


For all elements with the same name, I would like to return the maximum value.


No comments:

Post a Comment