Select Random Record Row from table in SQL Server

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.




ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Buy Books Online at Best Prices

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.