/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 votes342 views1 answer
Copy all values of a column to another column in sql in same table
SQL
1 vote394 views2 answers
Postgresql check privileges on schema
SQL
0 vote347 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote350 views1 answer
Dump db only triggers mysql
SQL
-1 vote343 views1 answer
Sql add column bit
SQL
1 vote409 views1 answer
How not to sort by average rating
SQL
7 votes427 views2 answers
3rd height salary sql
SQL
0 vote361 views1 answer
Mysql subtract month from timestamp
SQL
0 vote354 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote352 views1 answer
Luu ckeditor vao mysql
SQL