About the first n records of a data table

Introduce the writing method of the various data library of the first n record of a table ...

Author:ccbzzp


1. ORACLE
SELECT * from TABLE1 WHERE rownum<=n
2. INFORMIX
SELECT A-N * from TABLE1
3. DB2
SELECT * Row_number () over (order by COL1 DESC) as RowNum WHERE rownum<=n
Or
SELECT COLUMN from TABLE FETCH A/N ROWS only
4. SQL SERVER
SELECT Top N * 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