How to select distinct values from XML file

[EDN Admin]

Hi,
Iam new in XML, and I Cant resolve this problem.
I have the following XML file
<pre class="prettyprint <?xml version="1.0" encoding="UTF-8"?>
-<Students> -<Student Id="001 <Name>Poni</Name> <LastName>Mini</LastName> -<Courses> -<Course Id="01 <Name>C#</Name> </Course> -<Course Id="02 <Name>Java</Name> </Course> </Courses> </Student> -<Student Id="002 <Name>Isa</Name> <LastName>Israelis</LastName> -<Courses> -<Course Id="02 <Name>Java</Name> </Course> -<Course Id="03 <Name>Oracle</Name> </Course> </Courses> </Student> -<Student Id="003 <Name>Rafi</Name> <LastName>rafifa</LastName> -<Courses> -<Course Id="02 <Name>Java</Name> </Course> -<Course Id="03 <Name>Oracle</Name> </Course> </Courses> </Student> -<Student Id="004 <Name>Yosi</Name> <LastName>Koen</LastName> -<Courses> -<Course Id="04 <Name>SQL</Name> </Course> -<Course Id="03 <Name>Oracle</Name> </Course> </Courses> </Student> </Students>[/code]
I want to select two something
<ol>
All Courseshow many students studing in each cuerse</ol>
I know that I need to use XPATH maybe but i dont know how.
Can somebody help me please?
Thank you..
<br/>

View the full article