Introduction to the writing of various databases recorded in the N-note record ...
Author: 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 or SELECT COLUMN FROM TABLE FETCH FIRST N rows only 4. SQL Server SELECT TOP N * from table1 5. Sybase set rowcount n gosect * from table1 6. mysql select * from table1 limited n 7. FoxPro Select * Top n from table Order by Column
