To get random number in sql we use rand() function. But rand() funcition returns decimally random between 0 and 1. If we want to get between 1 and 100 we must multiply the number with top value. Then we must round the number. To round a number we can use 3 different methods. The first one floor method rounds the number to the integer floor value. The second one ceiling value, roundes to ceiling and the third one round method.

**Example 1** : Show random number between 0 and 100;

| Select floor(rand()*101)--If we want the 100 number to be selectable we must write 101 |

**Example 2** : Show random number between 1 and 100;

| Select ceiling(rand()*100)--0 is never selected because we use "ceiling" function |

**Example 3** : Show random number between 50 and 100;

| Select floor(rand()*50) + 50 |

**Example 4** : Show random number between 20 and 80;

| Select floor(rand()*60) + 20 -- 80 - 20 = 60 so we multiply with 60, then we add 20 |

__YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE__

### Like this:

Like Loading...

*Related*

best answer