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

afeigoo 发表于 2013-1-13 18:56:57

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

select * from (
select row_number() over() as rnum,ct.* from CT.T_City as ct)  as a
where rnum>10 and rnum<=20
 

查看完整版本: DB2 返回指定行数之间的结果集