Re: Different result with subquery

2006-02-21 Thread neroux
TED]> wrote: > Neroux, > > RAND() gives a roughly rectangular distribution, not a normal > distribution, so samples of fewer than 100 or so values from it are > likely to show large but statistically _insignificant_ differences. > In > larger samples, I don't see a

Different result with subquery

2006-02-21 Thread neroux
Hello, I am having a table with an integer column which I use for probability calculations (the higher a value the more often it is chosen). Now I am having the following query, which should actually incorporate these probabilities, however it seems to prefer values from the middle range SELE