Write the first few data records for oracle/db2/sqlserver/sybase/mysql Databases

Write the first few data records for oracle/db2/sqlserver/sybase/mysql databases. ORACLESELECT * FROM TABLE1 where rownum <= N 2. informix select first n * FROM TABLE1 where 1 = 1 3. DB2 SELECT * ROW_NUMBER () OVER (order by COL1 DESC) as rownum where rownum <= N or select column from table where 1 = 1 fetch first n rows only 4. SQL SERVER SELECT TOP N * FROM TABLE1 where 1 = 1 or SET ROWCOUNT N SELECT * FROM TABLE1 where 1 = 1 SET ROWCOUNT N1 5. sybase set rowcount n select * FROM TABLE1 where 1 = 1 set rowcount N1 Note: Execute set rowcount 0 to cancel ROWCOUNT setting 6. mysql select * FROM TABLE1 where 1 = 1 limit n 7. foxpro select * top n from table order by column 8. access select top n * FROM TABLE1 where 1 = 1