access：
select top (10) * from table1 where 1=1

db2：
select column from table where 1=1 fetch first 10 rows only

MySQL：
select * from table1 where 1=1 limit 10

sql server:
讀取前10條：select top (10) * from table1 where 1=1
讀取后10條：select top (10) * from table1 order by id desc
在sqlserver里面，如何讀取按照某個排序，第5到10這五個記錄
select top 6 * from table where id not in(select top 4 id from table)

Oracle：
select * from table1 where rownum<=10