Re: Help with SQL staterment - Mailing list pgsql-novice

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