Posted By

vedgiee on 11/18/10


Tagged


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Beppoi


SELECT RANDOM ROW


 / Published in: SQL
 

MS SQL Select a Random Row with NEWID()

  1. SELECT TOP 10 PERCENT *
  2. FROM tablename
  3. ORDER BY NEWID()

Report this snippet  

You need to login to post a comment.