Home >Database >Mysql Tutorial >随机抽取n个记录的SQL_MySQL
随机抽取n个记录的SQL_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:54:56966browse
mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MYSQL教程:备份数据库_MySQLNext article：MySQL教程：Replace INTO说明_MySQL