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