1、Sql server (2005或以上版本)、oracle、mysql
select * from (select row_number() over (order by ...) as rn from ...) as data where rn>0 and rn<=10
2、db2
select * from (select rownumber() over (order by ...) as rn from ...) as data where rn>0 and rn<=10
3、Infomix
select skip 0 first 10 * from ...
欢迎访问:http://121.18.78.216 适易查询分析、工作流、内容管理及项目管理演示平台