Query Help - Random records

Query Help - Random records

 

  

Hi everyone,

I need to create a query to randomly select 20% of the records in my
database. I am familiar with randomly creating numbers using RAND() and
am researching possible solutions. If anyone has any suggestions, I
would greatly appreciate it.

Mindy

MS Sql Server LazyDBA home page