The problem:

You need to pick certain number of rows from a SQL Server table in a truly random maner without favoring one row over another. For example, you have a table where each row represents a chance to win something and you have been tasked with the picking of 10 winning entries (truly randomly).

The solution

The solution is very simple considering the fact that newid() generates as close to truly random numbers as you can get. Simply run the following:
    select top 10 * from my_table order by newid()

Click here to go back to the SQL Server content index page.