How to randomly select 10% of the rows from a table

Question

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

Use NEWID() to force randomness.

SELECT TOP (10) PERCENT
       *
FROM sys.columns
ORDER BY NEWID();

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

thanks, Phil. Can I use random () to rewrite the same query?

Thanks.

Phil Parkin SSC Guru Points: 247158 More actions · Answer 3

SQL_Hunt wrote:

thanks, Phil. Can I use random () to rewrite the same query?

Please post the link to the T-SQL random() function that you intend to use.

BrainDonor SSCoach Points: 19262 More actions · Answer 4

Phil's solution is definitely the more elegant but (for completeness) there is also a TABLESAMPLE clause.

Steve Hall
Linkedin
Blog Site

Cookies on SQLServerCentral