Select Random Record | Row from table in SQL Server

Hello everyone, I am going to share the T-SQL query for select random row record from table using SQL Server 2012.

A NEWID() is use to generate for each rows and the table is sorted by using this and also  it returned  the first record.

This CHECKSUM() is used to detect change in a rows and also use for create index of a table.

The query detail as given below.

Table of Content

1. Syntax for select random record
2. Query for select random record

Syntax for select random record

SELECT TOP [Your_Number] * FROM [dbo].[Your_TableName] ORDER BY NEWID()

                                       OR

SELECT TOP [Your_Number] * FROM Your_TableName ORDER BY RAND(CHECKSUM(*) * RAND())

Query for select random record

SELECT TOP 1 * FROM [dbo].[User] ORDER BY NEWID()

                                 OR

SELECT TOP 1 * FROM [dbo].[User] ORDER BY RAND(CHECKSUM(*) * RAND())

For  detail example with live demo you can go below links.

https://msdn.microsoft.com/en-us/library/cc441928.aspx

http://blog.sqlauthority.com/2012/11/16/sql-server-retrieving-random-rows-from-table-using-newid/