[转]Select Top在不同数据库中的用法

 

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

select * from table LIMIT 5,10; #返回第6-15行数据 
select * from table LIMIT 5; #返回前5行 
select * from table LIMIT 0,5; #返回前5行
7. FOXPRO 
SELECT * TOP N FROM TABLE ORDER BY COLUMN