I am trying to find unique installed software and the highest version of the software installed.
There is a report with "All installed software"
That gives me 4 columns. SOftware Name, version, publisher and number if installations.
to start:
How would i change the sql to just report the heights version found if software name is the same.
if names column A "1,2,3,4,5....." are the same then compare "B" and return hights version.
Am i making sense? Should i have a different approach?
Thanks for any help.