TOP 之比较

Access、Sql Server：
select Top 10 * from myTable

MySql：
select * from myTable limit 10

DB2：
select * from myTable fetch first 10 rows only

ORACLE：
select * from myTable where rownum <= 10

 

SQLITE:
select * from myTable limit 10

 

Derby:

无此功能