How to get random number in SQL

Pramod Thakur

12y1.5kCode

In this code snippet we find a code of getting random number in sql server.

You can achieve this by following this code.

In this code you can find 4 digit random number.

select cast(rand() * 10000 as int ) as RandNo

If you want 6 digit random number then you use the following code snippet.

select cast(rand() * 1000000 as int ) as RandNo