Select Top -- Order By SQL Servef

Hello Expert. May I please have some assistance? I would like to do a select and retrieve one row. I would like to have the most recent modified date to be returned. This Table has multiple rows for the same client id. But the client id is my trigger for returning records.

Thanks for you assistance.