From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Help with SQL staterment |
Date: | 2011-06-30 23:04:46 |
Message-ID: | BANLkTin2xvC1PZebXO3XD8YNXzPtmYoE3w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 30 June 2011 23:25, Chris Campbell <ccampbell(at)cascadeds(dot)com> wrote:
>>It should look something like this:
>
>>SELECT contactkey, max(paymentdate)
>>FROM my_table
>>GROUP BY contactkey;
>
> Yeah, that's what I started with. The problem is that I "need" the payment key returned in addition to the other fields based on the max(paymentdate). When I add paymentkey to the mix I keep ending up with a cartesianed product showing multiple paymentkeys.
You can try this:
SELECT DISTINCT ON (contactkey)
paymentkey, contactkey, paymentdate
FROM
my_table
ORDER BY
contactkey, paymentdate DESC
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2011-06-30 23:23:41 | Re: Help with SQL staterment |
Previous Message | Steve Crawford | 2011-06-30 22:49:52 | Re: Help with SQL staterment |