Your Ad Here

advanced code snippet search

Posted By

vedgiee on 11/18/10


Tagged


Versions (?)

SELECT RANDOM ROW

 / Published in: SQL
 

MS SQL Select a Random Row with NEWID()

Expand | Embed | Plain Text 
  1. SELECT TOP 10 PERCENT *
  2.   FROM tablename
  3.   ORDER BY NEWID()

Report this snippet  

You need to login to post a comment.