/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

2 votes159 views1 answer
Sql float to int
SQL
2 votes210 views1 answer
Oracle to_char number format percentage
SQL
1 vote197 views2 answers
Postgresql backup and restore globals and data
SQL
18 votes189 views2 answers
Sql comments
SQL
11 votes211 views2 answers
Having in sql
SQL
0 vote204 views1 answer
Mysql identified by syntax error
SQL
0 vote211 views1 answer
Lesser than or equal to symbol in postgres
SQL
1 vote216 views1 answer
Tsql get beginning of year
SQL
2 votes210 views1 answer
Grant revoke privileges to mysql username
SQL
9 votes202 views2 answers
Mysql change value
SQL