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

1. ORACLE

    SELECT * FROM TABLE1 WHERE ROWNUM<=N 

2. MYSQL

    SELECT * FROM TABLE1 LIMIT N

3. INFORMIX

    SELECT FIRST N * FROM TABLE1

4. DB2

    SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY 

4. SQL SERVER

　 SELECT TOP N * FROM TABLE1

7. FOXPRO

　 SELECT * TOP N FROM TABLE ORDER BY COLUMN

8. postgres查询前几条记录SQL

    SELECT * FROM TABLE LIMIT