/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 vote103 views1 answer
Linebreak sql
SQL
3 votes105 views2 answers
Create schema postgres
SQL
9 votes117 views6 answers
Check constraint in sql
SQL
1 vote103 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote149 views1 answer
Mysql show schema
SQL
2 votes145 views1 answer
Tcl in sql
SQL
0 vote101 views1 answer
C# check if mysql query modified rows
SQL
0 vote119 views1 answer
Postgres foreign key multiple columns
SQL
0 vote138 views1 answer
Mysql get hour from datetime
SQL
0 vote167 views1 answer
Mysql disable triggers
SQL