各种数据库中,如何读取前10条记录

 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