/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 vote334 views1 answer
Oracle exchange subpartition
SQL
3 votes336 views1 answer
Unsigned int in mysql
SQL
0 vote346 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
8 votes352 views3 answers
Postgres database sizes
SQL
13 votes338 views3 answers
Insert mysql ifile nto database
SQL
1 vote338 views1 answer
Psql filed name alter
SQL
35 votes326 views6 answers
Postgres
SQL
9 votes343 views2 answers
Convert data type in sql
SQL
2 votes354 views1 answer
Oracle find constraints referencing a table
SQL
3 votes321 views2 answers
Mysql import gz
SQL