/SQL/Mysql select random rows large table

Mysql select random rows large table

SELECT name
  FROM random AS r1 JOIN
       (SELECT (RAND() *
                     (SELECT MAX(id)
                        FROM random)) AS id)
        AS r2
 WHERE r1.id >= r2.id
 ORDER BY r1.id ASC
 LIMIT 1;

Source: stackoverflow.com

Similar codes

0 vote224 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote257 views1 answer
Hour differeence in mysql
SQL
1 vote253 views1 answer
How to select the nth row in a SQL database table?
SQL
1 vote243 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote244 views1 answer
Custom row number
SQL
20 votes254 views6 answers
Change password in mysql
SQL
1 vote232 views1 answer
Error code 1055
SQL
0 vote223 views1 answer
Postgresql subquery
SQL
8 votes250 views2 answers
Sqlsrv default port
SQL
1 vote235 views1 answer
Select count distinct multiple columns sql server
SQL