The last time said, now needs a little change
ASSETID SOFTID SOFTNAME
1 to 10 v PRO 2012
1 11 VS PRO 2018
1 12 v PRO 2019
2 5 VS PRO 2017
2 and 9 v STA 2018
2 8 VS the STA 2016
After the screening data, the following data
Filtering rules: the same asset ID version number consistent software name, take a version number of the largest
More than one asset version number, and then show multiple, but once the version number repeat just take the largest version
ASSETID SOFTID SOFTNAME
1 12 v PRO 2019
2 5 VS PRO 2017
2 and 9 v STA 2018
CodePudding user response:

Post a picture look at intuitive,
CodePudding user response:
Into use after the let keyword to Max.CodePudding user response: