>>Spaseebo. Ochen khoroshaw. :-) But, why the lowest values instead of the highest?
>
>This is because
>
>
>... ORDER BY Field
>
>
>is the same as
>
>
>ORDER BY Field ASC
>* (ascending)
>
>
>So, random values are generated, the records are sorted in ascending order by this field (since ASCending is the default), and then the first "n" records - in the specified order - are selected.
>
>Of course, to obtain 150 random records, it is quite irrelevant whether you select the first 150, the last 150, or even (if there are enough records) the first 150 that have a value higher than 0.5, for example.
Okay. I see that the ORDER BY is critical then.
Thanks.
Ken