python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions