Postgres Pro
Downloads
Home   >   mailing lists

sql basic question - Mailing list pgsql-sql

From Antonio Parrotta
Subject sql basic question
Date
Msg-id CAByPMP+g1gWSb3=tkCGRXruf-xvwgGOX_-tkDJva9Sx_1oSxYQ@mail.gmail.com
Whole thread Raw
Responses Re: sql basic question
Re: sql basic question
List pgsql-sql
Tree view
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: msi77
Date:
Subject: Re: strange corruption?
Next
From: Anton Gavazuk
Date:
Subject: Re: sql basic question