To retrieve the record in random order from the existing created table. Then we can use an ' ORDER BY ' Clause with RAND() Function.
The basic syntax of the ORDER BY statement with RAND() or RANDOM() function is given below –
SELECT * FROM table_name ORDER BY RAND();/*on error use RANDOM()*/
SELECT * FROM employees ORDER BY RAND(); /*on error use RANDOM() */
Here it will retrieve random records from the employees' table.
Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique
Don't hesitate to give us a call or send us a contact form message