Select rows randomly from a table

• nasir afridi

  Mr or Mrs. 500

  Points: 518

  More actions

  April 9, 2002 at 2:21 pm

  #158282

  i am trying to select records randomly from a table. like 10% of all records or so, what can i use in SQL server to do this? i have tried RAND but that doesnt work or maybe i am not doing it rite.

• Eve

  SSCrazy

  Points: 2480

  More actions

  April 10, 2002 at 12:25 pm

  #426981

  There is an article on another forum that will give you what you are looking for:

  http://www.sqlteam.com/item.asp?ItemID=217