/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

-1 vote214 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
2 votes229 views4 answers
List databases in sql server
SQL
1 vote232 views1 answer
Check if mysql is installed
SQL
1 vote237 views1 answer
Delete from inner join sql
SQL
2 votes233 views2 answers
Mysql find max value row
SQL
0 vote221 views1 answer
Mysql jdbc timezone
SQL
8 votes253 views1 answer
Oracle search stored procedures for text
SQL
3 votes227 views2 answers
Postgresql remove not null constraint
SQL
0 vote226 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote252 views2 answers
How to truncate all table in mysql workbench
SQL