Re: [sqlite] problem using random() in queries

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

[sqlite] problem using random() in queries

I created a SQLite database where a table 'names' is located. This table stores just a single column called 'name'. Now I tried for test purposes to create a random number within range [0..1] for each record in the table using a SELECT statement like this: select name, (random() / 922337203685477