Content Explore
All
Database and Storage NoSQL Storage Graph SQL
Research and Development Algorithms Machine Learning NLP Intelligent Transport System Information Retrieval Coding Big data Message Queue Security Tips Network Design OS
Archives Others Hardware Web Design Software Web Develop

1.9 限制返回的行数

Published : 2008-11-13 Categories : Cookbook Tags : SQL DB2 MySQL Oracle PostgreSQL Database MSSQL limit FETCH FIRST ROWNUM TOP
Q: 如何限制查询中返回的行数
A: 使用数据库内置函数
DB2 ( 使用 FETCH FIRST 子句 )
SELECT *
FROM emp FETCH FIRST 5 ROWS ONLY
MyS...

Categories

All
Database and Storage NoSQL Storage Graph SQL
Research and Development Algorithms Machine Learning NLP Intelligent Transport System Information Retrieval Coding Big data Message Queue Security Tips Network Design OS
Archives Others Hardware Web Design Software Web Develop