/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 vote376 views1 answer
Date datatype in livesql
SQL
8 votes338 views1 answer
Database backup in mysql server recovery
SQL
0 vote330 views1 answer
Back up stored procedures mysql
SQL
0 vote342 views2 answers
Getting customers with no orders sql
SQL
21 votes363 views1 answer
SQL cheat sheet pdf
SQL
10 votes456 views4 answers
Sql server pagination
SQL
0 vote338 views1 answer
Postgresql log
SQL
1 vote329 views1 answer
Delete mysql from mac
SQL
4 votes350 views2 answers
Postgres update single column
SQL
4 votes298 views1 answer
And or sql order of operations
SQL