Igor Tandetnik wrote:
>
> Try this:
>
> select name, RNDValue
> from (
> select name, (random() / 9223372036854775807.0 + 1.0) / 2.0 as
> RNDValue from names
> )
> where RNDValue >= 0.99;
>
> Igor Tandetnik
>
>
Thank you for your answer. I tried the subselect and it seems that there is
no difference to the method posted above. There are still records with an
RNDValue less than 0.99 returned as result. :-(
I just tested it with the Win32 version of SQLite 3.6.1, maybe this is a
plattform specific problem or a general SQLite bug?
--
View this message in context:
http://www.nabble.com/problem-using-random%28%29-in-queries-tp19203274p19203871.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
