From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: last entry per person |
Date: | 2012-02-11 10:37:17 |
Message-ID: | jh5gct$mrl$4@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2012-02-03, garry <garry(at)scholarpack(dot)com> wrote:
> This is a multi-part message in MIME format.
> --------------060709070909070009090305
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: 7bit
>
> I have a table which holds a user name and their results in exams. There
> can be multiple entries per user. I am trying to return the last entry
> for each user. I can get the last entry in the table using the order
> by/limit method but how would this be applied per user. My table
> definition is like the following:
>
>> gradeid serial primary key,
>> user text,
>> grade char(1),
>> entered timestamp,
select distinct on (user) * from EXAMS order by entered desc;
--
⚂⚃ 100% natural
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2012-02-11 10:42:15 | Re: Let-bindings in SQL statements |
Previous Message | Jasen Betts | 2012-02-11 09:32:07 | Re: easy function or trigger to UPPER() all alpha data |