select top语句
1，oracle数据库
select * from table1 where rownum<=n
2，infomix数据库
select first n * from table1
3，db2数据库
select * row_number() over(order by col1 desc) as rownum where rownum<=n
--或
select column from table fetch first n rows only
4，sql server数据库
select top n * from table1
5，sybase数据库
set rowcount n
go
select * from table1
6，mysql/ target=_blank class=infotextkey>mysql数据库
select * from table1 limit n
7，foxpro数据库
select * top n from table order by column
