随机抽取n个记录的SQL


mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID() 本文作者:
« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3