If we want to fetch a random row in a table in MS SQL Server, the following path is followed.

SELECT TOP 1 * FROM {Table Name} ORDER BY NEWID()