Re: sql basic question

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(at)gmail(dot)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(at)gmail(dot)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
>
>