Oracle – Select record with max date only

I have the following query

When I run this query, it fetches me the following data –

I am getting every unique record for that particular visit type but I only want the record of the latest visiting date . So , my output should only contain –

This is just a sample dataset for demonstration purpose, my table has many employees, and I would want the record for their latest visit date along with the visit type for that latest date/time only.
I tried but it only fetches the topmost record whereas I would want it for every employee.


View on Stack Overflow