Select n random rows from SQL Server table

by 
select top 10 percent * from [yourtable] order by newid()

In response to the “pure trash” comment concerning large tables: you could do it like this to improve performance.

select  * from [yourtable] where [yourPk] in 
(select top 10 percent [yourPk] from [yourtable] order by newid())

The cost of this will be the key scan of values plus the join cost, which on a large table with a small percentage selection should be reasonable.

More Related Contents:

  1. Get the mentioned output by SQL query
  2. I need help formatting inner join command in SQL query
  3. Calculate a Running Total in SQL Server
  4. Conditional WHERE clause in SQL Server
  5. SQL NOT IN not working
  6. How to Join to first row
  7. Concatenate row values T-SQL
  8. GROUP BY to combine/concat a column [duplicate]
  9. Difference between “read commited” and “repeatable read”
  10. Reference alias (calculated in SELECT) in WHERE clause
  11. Implement paging (skip / take) functionality with this query
  12. Copy data into another table
  13. When to use Common Table Expression (CTE)
  14. How to replace a string in a SQL Server Table Column
  15. Can a Check constraint relate to another table?
  16. How to send email from SQL Server?
  17. SQL server ignore case in a where expression
  18. How To Create Table with Identity Column
  19. Find closest date in SQL Server
  20. SQL Server LIKE containing bracket characters
  21. Can we pass parameters to a view in SQL?
  22. SQL count(*) performance
  23. How to split string using delimiter char using T-SQL?
  24. Alternate of lead lag function in SQL Server 2008
  25. How do I create and query linked database servers in SQL Server?
  26. Add emoji / emoticon to SQL Server table
  27. Perform regex (replace) in an SQL query
  28. What is the internal representation of datetime in sql server?
  29. Cumulative Total in MS Sql server [duplicate]
  30. Export table data from one SQL Server to another

Leave a Comment