Re: sql basic question - Mailing list pgsql-sql

From Anton Gavazuk
Subject Re: sql basic question
Date
Msg-id -316905958645820213@unknownmsgid
Whole thread Raw
In response to Re: sql basic question  (Antonio Parrotta <antonioparrotta@gmail.com>)
List pgsql-sql
Antonio,

 but then you can do join between minmax select and source table by
distance and get required columns...

Thanks,
Anton

On Dec 28, 2012, at 12:43, Antonio Parrotta <antonioparrotta@gmail.com>
wrote:

Hi Anton,

I need column LABEL  and ID as well. By grouping on SIDE these column
cannot be included in the query.

Thanks

- Antonio


On 28 December 2012 12:38, Anton Gavazuk <antongavazuk@gmail.com> wrote:

> Do the child Select min, max from... Group by side
>
> Then you can do whatever is required...
>
> Thanks,
> Anton
>
> On Dec 28, 2012, at 12:23, Antonio Parrotta <antonioparrotta@gmail.com>
> wrote:
>
> Hi All,
>
> I have this table:
> LABEL     ID                  Distance                 SIDE
> "15";     119006;      0.10975569030617;        1
> "14";     64054;        0.118448307450912;      0
> "16";     64055;        0.176240407317772;      0
> "20";     64057;        0.39363711745035;        0
> "19";     64056;        0.41205442839764;        1
> "24";     119007;      0.59758734628752;        0
>
> What I want to achieve is a result table with min and max distance for
> each side, limiting to 2 (basically the boundaries of each SIDE)
>
> so the result should be:
> LABEL    ID                  Distance                 SIDE
> "15";     119006;      0.10975569030617;        1
> "19";     64056;        0.41205442839764;        1
> "14";     64054;        0.118448307450912;      0
> "24";     119007;      0.59758734628752;        0
>
>
> Thanks a lot
>
>
> - Antonio
> y
>
>

pgsql-sql by date:

Previous
From: Antonio Parrotta
Date:
Subject: Re: sql basic question
Next
From: Antonio Parrotta
Date:
Subject: Re: sql basic question