Home  >  Article  >  Backend Development  >  How to limit the number of retrieved rows in various databases? _PHP Tutorial

How to limit the number of retrieved rows in various databases? _PHP Tutorial

WBOY
WBOYOriginal
2016-07-13 17:00:55764browse

Currently there are only three databases known to implement this function!
mysql:select * from table limit 10
ORACLE:select * from table where rowid<10
msSQL:select top 10 from table

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631207.htmlTechArticleCurrently, only three databases are known to implement this function! mysql:select * from table limit 10 ORACLE:select * from table where rowid10 msSQL:select top 10 from table...
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