SQL SERVER RAND() Function to Generate Random Numbers

In this blog I will show you how to use SQL SERVER RAND() function to generate Random Numbers.

What is RAND() Function?

RAND() function in SQL is used to generate random numbers. It can create unique random numbers on execution. Let us check its usage in SQL Server.

Write the following SQL Snippet in query editor.

SELECT RAND() as RandomNo

 

Execute the preceding script and check the output.


We get a random number executing the preceding query. Please note the results will vary if you execute the same script in your SQL Server. Let us execute one more sql snippet to check more on random numbers.

Execute the following script,

SELECT RAND() as RandomNo
UNION ALL
SELECT RAND() as RandomNo
UNION ALL
SELECT RAND() as RandomNo
UNION ALL
SELECT RAND() as RandomNo

Let us check the output.



We get four different random numbers this time. We can implement RAND() function to generate random numbers in SQL in this manner.