select random row from sql table code example
Example 1: select random rows sql
Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);Example 2: sql pick random row
SELECT column FROM table
ORDER BY RAND()
LIMIT 1Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);SELECT column FROM table
ORDER BY RAND()
LIMIT 1