取随便数重复的有关问题

取随便数重复的问题
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