Input table: <br/>

UserId, CreateDate, EntityID <br/>
1 - 05.06.2000 - 1 <br/>
2 - 06.06.2000 - 1 <br/>
3 - 05.06.2000 - 2 <br/>


Output table: <br/>

UserId, CreateDate, EntityID <br/>
2 - 06.06.2000 - 1 <br/>
3 - 05.06.2000 - 2 <br/>

select * from
(select *,row_number()0ver(partition by id order by date desc) rn
from table
) a where a.rn=1