oracle: select * from table1 where rownum <=5 mysql: select * from table1 where 1=1 limit 5 sqlserver: 读取前5条:select top(5)* from table1 where 1=1 读取后5条:select top(5)* from table1 order by id desc access: select top(10)* from table1 where 1=1 db2: select column from table1 where 1=1 fetch first 10 rows only |
|