1行或多行
SELECT *
FROM app_student
WHERE id >=
(
(
SELECT MAX(id) FROM app_student)-(SELECT MIN(id) FROM app_student)) * RAND() + (SELECT MIN(id) FROM app_student)
LIMIT N
1行
SELECT * FROM app_student AS t1 JOIN (
SELECT ROUND(RAND() * ((
SELECT MAX(id) FROM app_student)-(SELECT MIN(id) FROM app_student))+(SELECT MIN(id) FROM app_student)) AS id) AS t2 WHERE t1.id >= t2.id
ORDER BY t1.id LIMIT 1
