Napríklad:
select k1.* from klienti k1 join (
select klient_id, max(created) created from klienti group by klient_id
) k2 on k1.klient_id=k2.klient_id and k1.created=k2.created;