Thread: SQL RAND() function and ORDER BY clause

Hi All,

In order to pick up the records in a random way, I use RAND() function. Opposite to this, I user ORDER BY. Without using ORDER BY, the query displays the records in a random order. Hence, I do not see any other use of RAND() function. Is this correct ? Are there any other benefits in RAND() function ?

Without "ORDER BY" clause, the rows are returned in an unpredictable way. However if the database is indexed, then the ordering will depend on such indexes.