取随便数重复的问题
select id,rand()*90 as b from Pub_Personnel
b 列取出的数据都是一样的,有没有办法可以每条记录得到自己的值
[解决办法]
select id, cast(rand()*90 as int)+1 as b from Pub_Personnel
[解决办法]
select id,rand()*90.0 as b from Pub_Personnel
[解决办法]
都说了
[解决办法]
select id,rand(id)*90 as b from Pub_Personnel