/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 vote186 views1 answer
Sql ssrs
SQL
1 vote151 views1 answer
Sql select table header
SQL
0 vote190 views1 answer
Shrink database file in sql server
SQL
0 vote219 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote175 views1 answer
Console output pl sql
SQL
0 vote174 views1 answer
Where date in datetime mysql
SQL
1 vote194 views1 answer
Connect to mysql database ubuntu
SQL
2 votes165 views1 answer
Anonymous block plsql
SQL
50 votes251 views6 answers
Sql count duplicate rows
SQL
0 vote178 views1 answer
Sqlite3 pragma foreign keys
SQL