extrobe
1/31/2017 - 2:14 PM

Select Random n% records from a table

Select Random n% records from a table

 Select n% random sample from a table 
 SELECT TOP 5 PERCENT * 
  FROM StageCustomers 
  ORDER BY NEWID()