Random Number of MySQL and MSSQL

Generation principle, to generate a random number between the A-B (pure number ):

Select floor (a + (RAND () * (B-A + 1 )))

 

MSSQL generates random numbers in batches:
Select ceiling (100 * rand (checksum (newid () from Table1

Select floor (100 * rand (checksum (newid () from Table1

 

MySQL generates random numbers in batches:
Select floor (200 + (RAND (UUID () * 351) from Table1

 

 

Simple analysis:
Floor (100.9) = 100
Floor returns the largest integer less than or equal to the given numeric expression.

Ceiling (100.1) = 101
Ceiling returns the smallest integer greater than or equal to the given numeric expression.

Tested. Yes
You can
Print floor (100.9)
Print ceiling (100.1)
Test