SQL Server Random Sort

by

This is a duplicate of SO# 19412. Here’s the answer I gave there:

select top 1 * from mytable order by newid()

In SQL Server 2005 and up, you can use TABLESAMPLE to get a random sample that’s repeatable:

SELECT FirstName, LastName FROM Contact TABLESAMPLE (1 ROWS) ;

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. Export from SQL Server to Excel
  3. hide/remove header and footer
  4. How do I generate a random number for each row in a T-SQL select?
  5. Auto increment primary key in SQL Server Management Studio 2012
  6. SQL Server Linked Server Example Query
  7. Combine multiple results in a subquery into a single comma-separated value
  8. Infinite loop CTE with OPTION (maxrecursion 0)
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. SQL Server: SELECT only the rows with MAX(DATE)
  11. Floor a date in SQL server
  12. PIVOT in sql 2005
  13. Get dates from a week number in T-SQL
  14. How do you get leading wildcard full-text searches to work in SQL Server?
  15. What are named pipes?
  16. How to connect to SQL Server with windows authentication from Node.JS using mssql module
  17. tsql returning a table from a function or store procedure
  18. How to update primary key
  19. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  20. How can I get the sum of multiple datetime values?
  21. Running an SSIS Package using dtexec
  22. Last executed queries for a specific database
  23. How do you determine what SQL Tables have an identity column programmatically
  24. Ampersand (&) operator in a SQL Server WHERE Clause
  25. Making an Entity Framework Model span multiple databases
  26. SQL Server 2008 Row Insert and Update timestamps
  27. SQL SERVER – Understanding how MIN(text) works
  28. Pivot multiple columns based on one column in SQL Server
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment