Re: [sqlite] SQLite Random number generator

2012/2/11 Igor Tandetnik : > On 2/10/2012 10:52 PM, Rick Guizawa wrote: >> Hi All, how do you generate a random number between two numbers in >> your query using the random() function? Thank's. > select random() % (:high  - :low) + :low; > Igor Tandetnik sqlite> select random()%(10-5)+5; 2 select

Re: [sqlite] SQLite Random number generator

On 2/10/2012 10:52 PM, Rick Guizawa wrote: Hi All, how do you generate a random number between two numbers in your query using the random() function? Thank's. select random() % (:high - :low) + :low; -- Igor Tandetnik ___ sqlite-users mailing list

[sqlite] SQLite Random number generator

Hi All, how do you generate a random number between two numbers in your query using the random() function? Thank's. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users