/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

10 votes127 views4 answers
Join with multiple conditions sql
SQL
0 vote128 views1 answer
How to check which sp is running in sql server
SQL
1 vote129 views1 answer
Get count by weekly pivot table sql server
SQL
10 votes143 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote140 views2 answers
Identity column in sql server
SQL
0 vote130 views1 answer
Sql show all users
SQL
0 vote176 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote127 views1 answer
Sql fetch next 10 rows pdo
SQL
-1 vote129 views1 answer
Sql getdate date only
SQL
0 vote113 views1 answer
Jooq finding lastest value in table
SQL