top 10问题,如何在不同的数据库中查询前几条记录?

1. ORACLE 
SELECT * FROM TABLE1 WHERE ROWNUM<=N

2. INFORMIX 
SELECT FIRST N * FROM TABLE1

3. DB2 
SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N 
或者
SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY

4. SQL SERVER 
SELECT TOP N * FROM TABLE1

5. SYBASE 
SET ROWCOUNT N 
GO
SELECT * FROM TABLE1

6. MYSQL 
SELECT * FROM TABLE1 LIMIT N

7. FOXPRO 
SELECT * TOP N FROM TABLE ORDER BY COLUMN

选择从10到15的记录
select * from (select * from (select * from  table_name  order by id asc) where rownum<16  order by id desc) where rownum<11 order by id asc