How several databases read the top N records

1. ORACLE Select * from TABLE1 Where rownum<=n

2. INFORMIX Select First N * from TABLE1 where 1=1

3. MYSQL Select * from TABLE1 where 1=1 LIMIT N

4. 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

5. SQL SERVER

Select TOP N * from TABLE1 where 1=1

Or

Set ROWCOUNT N Select * from TABLE1 where 1=1 SET ROWCOUNT N1

6. SYBASE

Set ROWCOUNT N Select * from TABLE1 where 1=1 SET ROWCOUNT N1

7. FOXPRO

Select * TOP N from TABLE OrDER by COLUMN

8. ACCESS

Select TOP N * from TABLE1 where 1=1

How several databases read the top N records