I have a table that contains a column that stores a version number for a record.
I want to select out each unique S_ID that contains the highest version number in the VER column.
I would like to select out each unique S_ID with the highest version number. My resulting selection would be:
Not sure how to perform this query. WOuld appreciate any ideas. Thanks