return only latest version of an item

[A. Steven Anderson]

Greetings!

I've got a pretty complex xquery that returns only the latest version of all
items in a collection, but I know there has got to be a more efficient way
to do it.

A simplified example of the XML that I'm dealing with (i.e. not invented
here) is as follows:

<items>
   <item>
      <id>1</id>
      <name>item # 1</name>
      <version>1</version>
   </item>
   <item>
      <id>1</id>
      <name>item # 1</name>
      <version>2</version>
   </item>
   <item>
      <id>1</id>
      <name>item # 1</name>
      <version>3</version>
   </item>
   <item>
      <id>2</id>
      <name>item # 2</name>
      <version>1</version>
   </item>
   <item>
      <id>2</id>
      <name>item # 2</name>
      <version>2</version>
   </item>
   <item>
      <id>3</id>
      <name>item # 3</name>
      <version>1</version>
   </item>
</items>

What would be the most efficient way to do this?

Thanks in advance!

-- 
A. Steven Anderson
Independent Consultant
http://x-query.com/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://x-query.com/pipermail/talk/attachments/20090514/caac92c0/attachment.htm