引用：http://blog.csdn.net/pric/archive/2004/09/19/109608.aspx
1. ORACLE
SELECT * FROM TABLE1 WHERE ROWNUM<=10
2. INFORMIX
SELECT FIRST 10 * FROM TABLE1
3. DB2
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=10
或者
SELECT COLUMN FROM TABLE FETCH FIRST 10 ROWS ONLY
4. SQL SERVER
SELECT TOP 10 * FROM TABLE1
5. SYBASE
SET ROWCOUNT 10
GO
SELECT * FROM TABLE1
6. MYSQL
SELECT * FROM TABLE1 LIMIT 10
7. FOXPRO
SELECT * TOP 10 FROM TABLE ORDER BY COLUMN
