Re: Select rows with the same value and assign a random number to them

[Peter Brawley]

Is this what you mean?

select distinct number, rand(number)
from tbl;