/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 vote231 views1 answer
Mariadb list tables
SQL
2 votes258 views3 answers
3 days back in sql server
SQL
0 vote259 views1 answer
Mysqldump ignore table
SQL
8 votes281 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote264 views1 answer
Mysql update even / odd rows
SQL
10 votes275 views6 answers
Sql between
SQL
0 vote298 views1 answer
Local pg_sql to heroku pg_sql
SQL
6 votes320 views2 answers
Oracle undotbs usage
SQL
0 vote301 views1 answer
Sql datum formatieren
SQL
1 vote269 views1 answer
Get last week data in mysql
SQL