2012/2/11 Igor Tandetnik <[email protected]>: > 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 abs(random()) % (:high - :low) + :low; -- Kit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
