SELECT * FROM organization
.org_robot
AS t JOIN (SELECT ROUND( RAND() * ((SELECT MAX(id) FROM organization
.org_robot
)-(SELECT MIN(id) FROM organization
.org_robot
)) + (SELECT MIN(id) FROM organization
.org_robot
)) AS id) AS t1 WHERE t.id>=t1.id ORDER BY t.id LIMIT 1
sql 随机一条数据 非 order by rand()
最新推荐文章于 2024-06-22 10:25:57 发布