If you have just one client for whom you want to get the data
SELECT TOP (1) Client, Date, Rep
FROM Tbl t
WHERE Client = 'JaneDoe'
ORDER BY Date DESCFor all clients
SELECT Client, Date, Rep
ROW_NUMBER() OVER (PARTITION BY Client ORDER BY Date DESC) AS RN
WHERE RN = 1;