/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 vote308 views1 answer
Materialized view redshift
SQL
0 vote272 views1 answer
Alter session set nls_language french
SQL
0 vote299 views2 answers
Postgres having
SQL
1 vote258 views1 answer
Metada in sql
SQL
0 vote331 views1 answer
Typical max-connect-errors mysql
SQL
0 vote318 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote300 views1 answer
Power bi union columns
SQL
0 vote276 views1 answer
Clone table structure mysql
SQL
2 votes338 views2 answers
Create table mysql integer NOT null
SQL
0 vote304 views1 answer
Query to remove duplicate rows from a table
SQL