From: | Tom Smith <tomsmith1989sk(at)gmail(dot)com> |
---|---|
To: | "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: get first and last row in one sql as two columns |
Date: | 2015-09-03 12:11:13 |
Message-ID: | CAKwSVFHvvcqfGLwZjbrnUWQ5jf5H0EXQJkstqM=ZcMt_zrnd-w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
The window function works for me (with adding limit 1 in the end to output
only one row
needed instead of many duplicate rows).
thanks very much.
On Thu, Sep 3, 2015 at 6:51 AM, Dickson S. Guedes <listas(at)guedesoft(dot)net>
wrote:
> On Wed, Sep 02, 2015 at 07:14:40PM -0400, Tom Smith wrote:
> > Hi:
> >
> > I need to get the first and last tow in one sql like below
> >
> > select first(col1), last(col1) from table order by col1
>
> Have you tried the window functions [1] last_value and first_value?
>
> You could use something like:
>
> SELECT first_value(col1) over (order by col1),
> last_value(col1) over (order by col1)
> FROM table;
>
> It should be as simple as that, or I miss your point.
>
>
> [1] http://www.postgresql.org/docs/current/static/functions-window.html
>
>
> []s
> --
> Dickson S. Guedes
> @guediz - http://github.com/guedes
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2015-09-03 12:44:02 | Re: get first and last row in one sql as two columns |
Previous Message | Dickson S. Guedes | 2015-09-03 10:51:06 | Re: get first and last row in one sql as two columns |