/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 votes148 views2 answers
Useradd postgres
SQL
7 votes151 views3 answers
Postgre describe table
SQL
0 vote152 views1 answer
Sql query to force the database to be drop
SQL
0 vote190 views1 answer
Kimball data warehouse sql calendar
SQL
5 votes144 views1 answer
Postgres integer to serial
SQL
0 vote155 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote167 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote157 views1 answer
Influxdb clone measurement
SQL
2 votes147 views2 answers
How to view created temporary tables in mysql
SQL
1 vote160 views1 answer
How to copy data of a table from another database to table of anaother database
SQL