I have an XML file that has duplicate record in it. In SQL Server I would do a SELECT DISTINCT. How can I achieve this with XML.
For example
<Pupils>
<Pupil pupilid="20">
<Name>Test test</Name>
</Pupil>
<Pupil pupilid="19">
<Name>Test Pupil</Name>
</Pupil>
<Pupil pupilid="20">
<Name>Test...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.