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
select s_id, max(ver) from table_name group by s_id, it works on me.
This should work
SELECT S_ID, MAX(VER)
GROUP BY S_ID
let me know if you need additional help