不同数据库获取前N条记录的Sql书写

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

   或者
         select * from (select * from tableName order by dbms_random.value) 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 

          select top N * from tableName order by newid()
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

 

 

http://blog.csdn.net/Senton/archive/2009/04/18/4090105.aspx

http://blog.csdn.net/Senton/archive/2009/08/03/4404101.aspx