sql在不同数据库查询前几条数据的方法

Answer 1

拿前10为例

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 

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