MS SqlServer
select top 10 * from table
MYSQL
select * from table where .... limit 10;
Oracle
select * from (select rownum r ,* from table) t where t.r > 5 and t.r <= 10; (最好用PLSQL游标来解决)
DB2
select * from payment fetch first 10 row only
MS SqlServer
select top 10 * from table
MYSQL
select * from table where .... limit 10;
Oracle
select * from (select rownum r ,* from table) t where t.r > 5 and t.r <= 10; (最好用PLSQL游标来解决)
DB2
select * from payment fetch first 10 row only