Sometimes your project require whenever a page load or user search then each time you need to show a random order or we can say different records or order.
To achieve this we can use following command
SELECT * FROM yourtableName order by NewID()
in below snap I am fetching person table of Adventureworks database
So each time when I press F5 I get different records or order.
The only thing which need to remember here NEWID() make your fetch slow on large collection so the best idea is use it with selected record set.
I hope this will help you somewhere enjoy.