/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 votes128 views1 answer
Postgresql update sequence next value
SQL
0 vote135 views1 answer
Pl sql turn off variable substitution
SQL
0 vote142 views1 answer
Get date ISO in psql
SQL
0 vote176 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote137 views1 answer
Get max salary from each department sql
SQL
0 vote125 views1 answer
Psql check if value in array
SQL
0 vote123 views1 answer
Create new table pl sql
SQL
5 votes158 views3 answers
Show indexes mysql
SQL
16 votes134 views4 answers
Ascending order mysql
SQL
-1 vote142 views1 answer
Mysql select count if contains
SQL