Return rows in random order
This is the simplest solution:
SELECT quote FROM quotes ORDER BY RAND()
Although it is not the most efficient. This one is a better solution.
SELECT * FROM table
ORDER BY NEWID()
This is the simplest solution:
SELECT quote FROM quotes ORDER BY RAND()
Although it is not the most efficient. This one is a better solution.
SELECT * FROM table
ORDER BY NEWID()