Home >Database >Mysql Tutorial >如何提取除最新十条记录之外的所有记录？_MySQL
如何提取除最新十条记录之外的所有记录？_MySQL
- WBOYOriginal
- 2016-06-01 14:06:131195browse
select * from table1 where id not in (select top 10 Id from table1 order by inidate)
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：如何将Access和Excel导入到Mysql中之一_MySQLNext article：如何将Access和Excel导入到Mysql中之三_MySQL