Re: [SQL] sql basic question

2012-12-28 Thread Antonio Parrotta
min and > max > distance for each side". > > Okay, with SIDE in 0,1,-1,2,-2,3,-3 there are exactly 14 possible values > for > each SIDE and Min/Max. > > > If this is wrong, describe your problem better. > > > > > Antonio Parrotta hat am 28. Dezember 20

Re: [SQL] sql basic question

2012-12-28 Thread Antonio Parrotta
Hi Andreas, Anton, I did some test and both queries didn't worked. Maybe I was not clear with the example provided. My table contains more than 160K records with SIDE 0, 1, -1, 2, -2, 3 and -3. Example provided is a very small subset. *Andrea's *query is failing because it is getting only distinc

Re: [SQL] sql basic question

2012-12-28 Thread Antonio Parrotta
gt; > Thanks, > Anton > > On Dec 28, 2012, at 12:23, Antonio Parrotta > wrote: > > Hi All, > > I have this table: > LABEL ID Distance SIDE > "15"; 119006; 0.10975569030617;1 > "14&

[SQL] sql basic question

2012-12-28 Thread Antonio Parrotta
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";