Is there a function or some kind of method that I can include in a SELECT sql statement that will pull all of the records from a table in a random order?
Or will I have to use some asp to shuffle the records?
I guess I don't have to ask 'is this possible?'
Thanks in advance
Hello,
I was wondering if there is a way to randomise a recordset once you have performed a query.
eg I want my query return a set of records based upon criteria supplied and then either randomise the order of the recordset or only return 3 random records - which every is simplest to do.
Can this be done in SQL or do I need to handle it outside of my SQL query in my business logic?
Many Thanks