SQL statements that display only the first few data how to use select top in seven databases

2. How to use Select top in seven types of databases
6. 1. Oracle Database
10. SELECT * from TABLENAME WHERE ROWNUM <= N
14. 2. Infomix Database
18. SELECT First N * from TABLENAME
22. 3. DB2 Database
26. SELECT *
28. From (SELECT * row_number () + ({ORDER by COL1 DESC}) as ROWNUM from TABLENAME)
30. WHERE ROWNUM <= N
32. Or
34. SELECT COLUMN from TABLENAME FETCH first N ROWS only
38. 4. SQL Server Database
42. SELECT TOP N * from TABLENAME
46. 5. Sybase database
50. SET ROWCOUNT N
52. GO
54. SELECT * from TABLENAME
58. 6. mysql Database
62. SELECT * from TABLENAME LIMIT N
66. 7. FoxPro Database
70. SELECT * TOP N from TABLENAME ORDER by COLUMN

SQL statements that display only the first few data how to use select top in seven databases