MYSQL随机取出20条数据

SELECT * FROM `table`
WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`)))  dtTime > '2013-05-11'
ORDER BY id LIMIT 20;
---------------------
作者:tangpeng527
来源:CSDN
原文:https://blog.csdn.net/tangpeng527/article/details/51803239
版权声明:本文为博主原创文章,转载请附上博文链接!

相关推荐

网友评论(0)