Try this:

select s_id, max(ver) from table_name group by s_id, it works on me.

Thanks