Random values

[Bart]

Is there a way to write an SQL statement to choose random values from a particular select statement..for example:
select * from address
I was thinking, if there was a way to use an include statement for it like:
select * from address where id IN ('generates some random values&#39

thanks in advance

[Paul]

Unfortunately there is no simple way in sql to do this, but if you are looking to create test data for a database design to see how the table design handles large quantites of data there are several products out there for creating test data. Although one of my favorite products for doing this was killed(Test Bytes) by Cumputer Associates. I have been told there are products out there that do create dummy data for stress test analysis.

Thanks,

Paulie


------------
Bart at 12/24/2001 11:11:46 AM


Is there a way to write an SQL statement to choose random values from a particular select statement..for example:
select * from address
I was thinking, if there was a way to use an include statement for it like:
select * from address where id IN ('generates some random values&#39

thanks in advance

[Juergen Leis]

You can use the RAND() or RAND(seed) function


------------
Bart at 12/24/2001 11:11:46 AM


Is there a way to write an SQL statement to choose random values from a particular select statement..for example:
select * from address
I was thinking, if there was a way to use an include statement for it like:
select * from address where id IN ('generates some random values&#39

thanks in advance