關于數据庫取表的前N條記錄

答案：
 


介紹取一表前N筆記錄的各种數据庫的寫法... 

作者﹕CCBZZP


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

上一个：增加一个判断内存变量存在的函数
下一个：Tip如何在SQL*PLUS中插入含有&的字符串?