Re: filtering a rows based on latest date which has similar column values except date

[Peter Brawley]

Is this what you mean?

select p.candidateId, p.amount, c.firstname, max(p.paymentdate)
from payment p
join candidate c using(candidateId)
group by p.candidateId, p.amount, c.firstname;