Help with SQL Query- Please

Help with SQL Query- Please

Post by Raghavan Rajendra » Wed, 20 Oct 1999 04:00:00



Hi,
Can somebody help me with a method in which I sample random 10% of the
result set of a query.
I.E:
I run a query and generate a resultset of say 50,000 records.
I need to extract 10% or 5000 random records from this

How can I do it in an efficient way ?

Please help
Regards
Raj