1.oracle
select * from table1 where rownum <=10
2.informix
select frist 10 * from table1 where 1 = 1
3.DB2
select * row_number() over(order by col1 desc) as rownum where rownum <=10
4.SQL SERVER
select top 10 * from table1 where 1 = 1
or
set rowcount 10 select * from table1 where 1 = 1 set rowcount 100
5.sybase
set rowcount 10 select * from table1 where 1 = 1 set rowcount 100
6.mysql
select * from table1 where 1 = 1 limit 10 --取前10条记录
select * from table1 where 1 = 1 limit n,10 --从第n条开始,往后取10条记录,n从0开始.
7.foxpro
select * top 10 from table order by column
8.access
select top 10 * from table1 where 1 = 1
