Selecting rows with max attribute value

Question

I've the following table

and I want to come up with the following table

What I want is to select rows with largest version of each client. Tahnks in advance.

Answer 1

select * from 
(
select *,rn=Dense_rank()over(partition by Clientid order by version desc) from table
)x
where x.rn=1

FIDDLE DEMO

Answer 2

Try this

SELECT * From Table1 T
         JOIN (SELECT clientid,Max(version) As MVer 
               From Table1 Group By clientid) S
         ON T.clientid = S.clientid And T.version  = S.MVer

Fiddle Demo