Hi,
I am having trouble extracting node set of records with unique Codes for each City.

For this I am first getting all the records nodeset for a city and then trying to get unique code nodeset from the city nodeset.

I tried using these XPath expressions.

DAL_OUTPUT/RECORD[(CITY ='NEWYORK')][(not(CODE = preceding-sibling::RECORD/CODE))]


DAL_OUTPUT/RECORD[(CITY ='NEWYORK') and (not(CODE = preceding-sibling::RECORD/CODE))]

I would really appreciate if someone can help me here.

Input xml is something like this:

<DAL_OUTPUT>
   <RECORD>
      <CITY>NEWYORK</CITY>
       <CODE>1778</CODE>
   </RECORD>
   <RECORD>
      <CITY>ATLANTA</CITY>
      <CODE>1779</CODE>
       </RECORD>
   <RECORD>
      <CITY>NEWYORK</CITY>
      <CODE>1779</CODE>
   </RECORD>
   <RECORD>
      <CITY>NEWYORK</CITY>
      <CODE>1778</CODE>
   </RECORD>
   <RECORD>
      <CITY>ATLANTA</CITY>
       <CODE>1889</CODE>
   </RECORD>
   <RECORD>
      <CITY>ATLANTA</CITY>
      <CODE>1889</CODE>
    </RECORD>
</DAL_OUTPUT>