/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

10 votes182 views4 answers
Sql pagination
SQL
1 vote196 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote176 views1 answer
Mysql count by month
SQL
1 vote201 views1 answer
Get current date in pyspark sql
SQL
0 vote170 views1 answer
C# datetime to sql server datetime
SQL
18 votes175 views6 answers
Creating table in MySQL
SQL
48 votes284 views3 answers
Psql create database
SQL
6 votes173 views2 answers
Mysql concatenate two columns into one
SQL
0 vote183 views1 answer
Move table to a different schema
SQL
0 vote190 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL