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.
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.
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 [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 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..
|