/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

6 votes306 views3 answers
Mysql create database utf8
SQL
0 vote257 views1 answer
Store query result in variable sql
SQL
0 vote270 views1 answer
Oracle list index on table
SQL
4 votes314 views2 answers
Oracle drop job
SQL
0 vote360 views1 answer
Split first name and last name in sql
SQL
0 vote297 views1 answer
Get date ISO in psql
SQL
12 votes281 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote275 views1 answer
Sql server split string and insert into table select
SQL
7 votes297 views4 answers
What is my mysql version
SQL
0 vote313 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL