Random Selection

• ckmoied

  Ten Centuries

  Points: 1092

  More actions

  October 8, 2007 at 1:35 am

  #175795

  Just like select top 100 *, returns the top 100 records from the database,

  Is there a select statment which can give me 100 randomly selected records.

  something like

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 8, 2007 at 2:25 am

  #739917

  SELECT * FROM MyTable ORDER BY NEWID()

  --Ramesh
  

  ---