Random field selection 1

[Samdavo]

I need to randomly select x amount of records from a table i.e. if the table holds 100 records I need to return 10 totaly random records.

 

[MikeJones]

What DB are you on?

 

[Samdavo]

We are using an Oracle 8i DB on NT

 

[MalcolmW]

Ignoring the larger philosophical question as to whether there is anything totally random in life,
select * from YourTable where dbms_utility.get_hash_value(dump(rowid),0,100)<10 Malcolm

 

[Samdavo]

Thanks you for your help Malcom that has worked a treat