You can get records in random order from a sql query using NEWID( ) Function.
Check this in SQL Server, we can get records in random order from a sql query using NEWID( ) Function.
Like:
SELECT Name FROM UserDetail ORDER BY NEWID( )
Enjoy programming.......