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.
Could you provide a sample query and data that you're using?