数据库查询前几页

SQLServer: select top 10 from table;

Oracle: select * from table where rownum<=10;

MySql: select * from table limit 10.

转载于:https://blog.51cto.com/2534683/517038