Using an inventory comparison
File: Data.xml <order> <car model="A"> <id>0001</id> <name language="en">name 1</name> </car> <car model="B"> <id>0002</id> <name language="en">name 2</name> </car> <car model="B"> <id>0003</id> <name language="en">name 3</name> </car> </order> File: Query.xquery let $prods := doc("Data.xml")//car for $prod in $prods where $prod << $prods[@model = $prod/@model][last()] return $prod Output: <?xml version="1.0" encoding="UTF-8"?> <car model="B"> <id>0002</id> <name language="en">name 2</name> </car>