Hi folks :D,
not posted for a while but I have an interesting problem to solve.
Lets say I have a schema in my tamino database called ‘customer’ and a customer document looks like this.
<customer> <id>12345</id> <firstname>Ian</firstname> <surname>Gratton</surname> <house-no>1</house-no> <street>XML Avenue</street> <post-code>DE21 2XX</post-code> </customer>
I need to be able to list all customer documents that have
duplicated surnames AND duplicated house-no AND duplicated post-codes.
The xquery distinct-values() function is great for removing duplicates but in this case I want only the duplicates.
Any ideas :?:
Thanks in advance.