Select Statement Assistance

[weng]

This should work
SELECT S_ID, MAX(VER)
FROM <table)
GROUP BY S_ID

let me know if you need additional help