sql 取 指定范围内的两位小数

2019独角兽企业重金招聘Python工程师标准>>>

DECLARE @n DECIMAL(4,2)
 WHILE 1=1
 begin
 SELECT @n=FLOOR(RAND()*1000)/1000
 IF @n BETWEEN 100 AND 0.345
 break
 END
 SELECT @n

转载于:https://my.oschina.net/u/2446847/blog/1536407