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  彩虹雨·洋  阅读(25)  评论(0编辑  收藏  举报