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 <antonioparro...@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
