Forum Discussion
Solved
Return only rows with max value from specific column
I am trying to only get the max values from a certain column in a table Data looks like this: SalesOrderArchive SalesOrderNo ; Version_No ;MoreColumns SO1 ; 1 ; Datalines SO1 ; 2 ; Datalines S...
If you 'Group By' SalesOrderNo and include 'All Rows'
then Expand the table that results.
You will have to remove duplicates and tidy as necessary
