Skip to main content

Posts

Showing posts with the label 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 Syntax for select random record 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...