如何使用纯SQL选择N个随机行？

SELECT * FROM table_name ORDER BY RAND() LIMIT N;

CREATE TEMPORARY TABLE temp_table
SELECT * FROM table_name;

SELECT * FROM temp_table
ORDER BY RAND()
LIMIT N;

DROP TEMPORARY TABLE temp_table;

CREATE TEMPORARY TABLE temp_table
SELECT * FROM table_name;

SELECT * FROM temp_table
WHERE RAND()<(SELECT (1/COUNT(*))*10 FROM temp_table)
LIMIT N;

DROP TEMPORARY TABLE temp_table;