Random Samples

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to pull a random sample of 1000 from a database of 6000 records.
When I use the Sampling function in Data Analysis, it only allows me to pick
a numerical column and pulls the sample from that without bringing over the
additional informaion in the record. I need a random sample of emails for a
survey. How do I generate the sample so all record information is included?
 
Hi,
If your database is sql server you can do
select top 1000 * from table order by new_id()
 
Back
Top