Re: last entry per person
| От | Chris Travers |
|---|---|
| Тема | Re: last entry per person |
| Дата | |
| Msg-id | CAKt_ZftpbffmUMrAawXUg-eGAFPWPaPLNvkumJ5NLs4ygN=wGw@mail.gmail.com обсуждение исходный текст |
| Ответ на | last entry per person (garry <garry@scholarpack.com>) |
| Ответы |
Re: last entry per person
Re: last entry per person |
| Список | pgsql-general |
On Fri, Feb 3, 2012 at 12:26 AM, garry <garry@scholarpack.com> wrote:
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,Any help would be appreciated.
user text,
grade char(1),
entered timestamp,
Regards
What about a combination of a common table expression and a windowing function? You ought to be able to order by your criteria and then pull where the rowcount in the window is 1.
Best Wishes,
Chris Travers
Chris Travers
Garry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: