Get records in random order from a sql query in sql server.

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