/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 vote123 views1 answer
How to connect sql server using ip address in c#
SQL
2 votes162 views1 answer
Sql like variable
SQL
0 vote196 views1 answer
Mysql workbench not showing schemas
SQL
5 votes179 views4 answers
Change auto increment mysql
SQL
0 vote156 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote135 views1 answer
Mysql offset from bottom
SQL
1 vote171 views1 answer
Spark sql concatenate string and int
SQL
1 vote204 views1 answer
Mysql print variable
SQL
0 vote165 views1 answer
Sql case sttement with set
SQL
5 votes242 views1 answer
Oracle source query
SQL