midea2 发表于 2016-11-17 06:00:05

DB2 返回指定行数之间的结果集

　　select * from (
select row_number() over() as rnum,ct.* from CT.T_City as ct)  as a
where rnum>10 and rnum<=20
页: [1]
查看完整版本: DB2 返回指定行数之间的结果集