Hi, Thanks for responding so quickly. I tried using top 1 however it didn't return the results expected. I've attached a *.png file to show what the data in the table looks like. What I'm trying to do is return the APPL_CURRENT_STATUS based on the most recent APPL_CURRENT_STATUS_DATE. A person could have multiple rows.

so, the results should be:

1643399 AT

1661418 AT

1691213 MS