SELECT * FROM article AS t1 JOIN (SELECT ROUND( RAND() * ( (SELECT MAX(id) FROM article) - (SELECT MIN(id) FROM article)) + (SELECT MIN(id) FROM article) ) AS id ) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10;
发布:小五六资源网 2021年2月3日 6:47 星期三分类: Java
SELECT * FROM article AS t1 JOIN (SELECT ROUND( RAND() * ( (SELECT MAX(id) FROM article) - (SELECT MIN(id) FROM article)) + (SELECT MIN(id) FROM article) ) AS id ) AS t2 WHERE t1.id >= t2.id ORDER BY t1.id LIMIT 10;
发表评论: