Fetch unique records based on Latest Date in SQL Server

I have a query, which Join few tables and give the below result:

NOTE: Like above records, I have many more records in the table where only Rev_Id is unique for each row. 

Requirement: I want to fetch records for each row based on Latest Date, i.e., fetch all the rows that has unique "Version" column with Latest date.. so that I get below result:

For above result, I tried using below query in existing query:

Where Date = (select max(Date) from Table) 

But unable to get the desired result. Please help me how to achieve the result.

NOTE: I am using Oracle DB.