On 06/30/2011 04:04 PM, Thom Brown wrote:
> SELECT DISTINCT ON (contactkey)
> paymentkey, contactkey, paymentdate
> FROM
> my_table
> ORDER BY
> contactkey, paymentdate DESC
Gives the same result as my example but your solution is much cleaner.
Cheers,
Steve