/SQL/Select random sql

Select random sql

Select random sample sql

 Using a SAMPLE clause, we can select random rows.
SELECT * FROM table_name SAMPLE(10);

1

Select random sql

SELECT column FROM table ORDER BY RAND() LIMIT 1

0

Select random sql

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1

-1

Source: stackoverflow.com

Similar codes

1 vote236 views1 answer
Mysql return text after a final full stop
SQL
0 vote200 views1 answer
Get who is hired in february in sql
SQL
13 votes204 views3 answers
Insert mysql ifile nto database
SQL
8 votes196 views1 answer
Oracle search source code
SQL
13 votes193 views5 answers
Oracle list tables
SQL
2 votes180 views2 answers
How to get capital letter first in sql
SQL
0 vote192 views1 answer
Restore backupfile discourse
SQL
0 vote209 views3 answers
Sql query checker
SQL
0 vote179 views1 answer
Full syntax inner join
SQL
3 votes220 views2 answers
Mysql select database
SQL

Share