Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 随机抽取n个记录的SQL_MySQL

随机抽取n个记录的SQL_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-01 13:54:56
Original
963 people have browsed it

mysql: select * from tablename order by rand() limit 10
sqlserver: select top 10 * from tablename order by NEWID()

Related labels：
Record
Previous article：MYSQL教程:备份数据库_MySQL Next article：MySQL教程：Replace INTO说明_MySQL
Statement of this Website
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
Latest Articles by Author
Latest Issues
I followed the teacher’s code but kept reporting this error: 500 (Internal Server Error)
From 1970-01-01 08:00:00
0
0
0
Log in to phpMyadmin and get an error: The requested URL /phpMyAdmin/ was not found on this server.
From 1970-01-01 08:00:00
0
0
0
buttonbutton
From 1970-01-01 08:00:00
0
0
0
Internal Server Error 500 Error when submitting login information
From 1970-01-01 08:00:00
0
0
0
Why are the username and the following input box not on the same line? The password problem is the same as above.
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template