/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

0 vote178 views1 answer
Postgresql delete multiple rows
SQL
5 votes181 views1 answer
Purge undo tablespace usage
SQL
10 votes174 views1 answer
Oracle dba_dependencies
SQL
3 votes198 views1 answer
Oracle show trigger code
SQL
1 vote187 views1 answer
Select not matching data with join table
SQL
1 vote189 views1 answer
Table valued functions in sql
SQL
0 vote181 views1 answer
Sql server insert inner join
SQL
1 vote163 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote193 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote205 views1 answer
Mysql get nested records
SQL