ruilog
Notebook
Blog
About
Content Explore
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...
1
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