A quick post for all –
We often find situations where we need to retrieve random records from a MS SQL table. The below query does the same for you.
To generate a random record from a table in Microsoft SQL Server, we need to execute the following query:
SELECT TOP 1 * FROM tbl_name ORDER BY NEWID()