How do I fetch a random record from SQL Server, I want to display data randomly on a page from the database.
I found the in MYSQL we can use something like order by rand() and get the first record. Do we have something similar in SQL Server
Regards,
Freelancer
