/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

0 vote137 views1 answer
Many rows to 1 string mysql
SQL
0 vote139 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote113 views2 answers
Disallowed function mysql to_date()
SQL
0 vote100 views1 answer
Limiting query result using where in sql
SQL
0 vote94 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote107 views1 answer
View t-sql mail configuration
SQL
2 votes109 views1 answer
How to make insert script from table in SQL server
SQL
1 vote125 views1 answer
Sql select sum group by id laravel
SQL
0 vote116 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote114 views1 answer
Add super privilege mysql
SQL

Share