Say I want 10000 random numbers between 100 and 1000 how can I do that without selecting from a table? I know I can do: select abs(random() %(1000 - 100)) + 100 as rnd from TableWith10000Rows but there must be a better way.
RBS
Say I want 10000 random numbers between 100 and 1000 how can I do that without selecting from a table? I know I can do: select abs(random() %(1000 - 100)) + 100 as rnd from TableWith10000Rows but there must be a better way.
RBS