MySQL进行随机查询

SELECT * FROM ds_exam
WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM ds_exam)))
ORDER BY id
LIMIT 10

posted @ 2022-12-12 17:57  彩虹雨·洋  阅读(33)  评论(0)    收藏  举报