CODEWITHSUNDEEP
sqlsql-server
brk
brk

Reputation: 427

How to create a negative random number in sql server?

I am using SQL Server 2017 and I want to know, how can I generate a random number between 0 and -6

Upvotes: 2

Views: 2039

Answers (2)

CR241
CR241

Reputation: 2613

It might works for you:

DECLARE @Random INT;
DECLARE @Upper INT;
DECLARE @Lower INT

---- This will create a random number between 0 and -6
SET @Lower = -6 ---- The lowest random number
SET @Upper = 0 ---- The highest random number
SELECT @Random = ROUND(((@Upper - @Lower -1) * RAND() + @Lower), 0)
SELECT @Random

Upvotes: 2

Gordon Linoff
Gordon Linoff

Reputation: 1269943

You can do:

select ( 0 - floor(rand(checksum(newid())) * 7) )

Upvotes: 8

Related Questions