/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

3 votes293 views2 answers
Sqlite show table structure
SQL
0 vote282 views1 answer
Sql date between one week
SQL
0 vote274 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote302 views1 answer
Implode in sql query
SQL
4 votes261 views1 answer
Psql get sequences
SQL
4 votes309 views1 answer
Postgres delete last row
SQL
-1 vote262 views1 answer
MYSQL stored procedure select from
SQL
0 vote283 views1 answer
Enable sql server full text indexing
SQL
2 votes275 views4 answers
Duplicate record mysql
SQL
0 vote270 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL