Feb 10, 2017
Sqlite: how to generate a random number within range 0..99
Random()
The Sqlite random() function will returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
abs() will returns the absolute value of the numeric argument
floor() or round() will return a floating-point value X rounded to Y digits to the right of the decimal point. If the Y argument is omitted, it is assumed to be 0.
NB:floor() will only work within SQLExplorer, Dbeaver, ...
Result
select floor(abs(random()/92233720368547758.07));will generate within 0..99
and
select round(abs(random()/92233720368547758.07),0);
will generate within 1..100
Subscribe to:
Post Comments (Atom)
Popular Posts
-
What is it lately, this unexplainable need to change everything that works ? What about this idiom " if it ain't broke, don't ...
-
Hannah Wagner (better known by her stage name Miss Hannah Minx; born Oct. 1990) is an American vlogger known on Youtube for her Kawaii ...
-
After I gave a shot at ArtRage2 bundled with the Wacom tablet, I took the other cd that was in the box - and installed .... Photoshop Eleme...
No comments:
Post a Comment