Ask Your Question

How can one choose a random number from a particular range in SQL Server?

asked 2022-10-26 11:00:00 +0000

ladyg gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2022-01-17 13:00:00 +0000

david gravatar image

One way to choose a random number from a particular range in SQL Server is to use the RAND() function in combination with the desired minimum and maximum values. Here is an example SQL query:

SELECT CAST(RAND() * (@maxValue - @minValue) + @minValue AS INT) AS RandomNumber

In this query, @maxValue and @minValue are input parameters representing the maximum and minimum values of the desired range. The RAND() function generates a random float value between 0 and 1, which is then multiplied by the range and added to the minimum value. The CAST function is used to convert the result to an integer. This query will return a random integer within the specified range.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-10-26 11:00:00 +0000

Seen: 10 times

Last updated: Jan 17 '22