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/

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link.. My Tech Blog - https://www.code-sample.com/ My Books - Book 1 and Book 2