How to write a search to remove duplicates on software inventory?

[waJesu]

I have a list of software installed in our environment but some of the software have several entries duplicated with the different versions. How do I clean up the list by removing the other versions and remaining with the latest version for each software. I need help with a query for this. The query must create a corrected list of the software.

[johnhuang]

Could you provide a sample query and data that you're using?