last_updated_date column

[jmodic]

select name, sal, last_update_date from
(select name,
        sal,
        last_update_date,
        row_number() over (partition by name
                           order by last_update_date desc) as rn
   from my_table
)
where rn = 1;