Re: sql basic question

Поиск
Список
Период
Сортировка
От Antonio Parrotta
Тема Re: sql basic question
Дата
Msg-id CAByPMPJ6hqvF-2fGG_hxEktbXq4KVWN+0GPU9vkrjiJNMx5A4g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: sql basic question  (Anton Gavazuk <antongavazuk@gmail.com>)
Ответы Re: sql basic question
Re: sql basic question
Список pgsql-sql
Дерево обсуждения
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 по дате отправления: