/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

1 vote178 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote217 views1 answer
Sql grant select only
SQL
0 vote191 views1 answer
Oracle change password expiration policy
SQL
1 vote189 views1 answer
Give a column name to values generated from case statement in sql
SQL
3 votes204 views1 answer
Where id is in list sql
SQL
0 vote248 views1 answer
Select * where id = 1,2,3
SQL
1 vote189 views2 answers
Sql left characters
SQL
4 votes318 views1 answer
What are the data types
SQL
0 vote193 views1 answer
Sql update subtract value
SQL
1 vote271 views1 answer
Oracle transaction rollback not working
SQL