1. Oracle数据库
SELECT * FROM TABLENAME WHERE ROWNUM <= N
2. SQL Server数据库
SELECT TOP N * FROM TABLENAME
3. Sybase数据库
SET ROWCOUNT NGOSELECT * FROM TABLENAME
4. MySQL数据库
SELECT * FROM TABLENAME LIMIT N
1. Oracle数据库
SELECT * FROM TABLENAME WHERE ROWNUM <= N
2. SQL Server数据库
SELECT TOP N * FROM TABLENAME
3. Sybase数据库
SET ROWCOUNT NGOSELECT * FROM TABLENAME
4. MySQL数据库
SELECT * FROM TABLENAME LIMIT N