1、输出前10行
select * from DBtable fetch first 10 rows only
2、输出第10行(不包含)到第20行(包含)
select * from (select row_number() over() as rn,DT.* from DBtable as DT) as a where rn>10 and rn<=20
1、输出前10行
select * from DBtable fetch first 10 rows only
2、输出第10行(不包含)到第20行(包含)
select * from (select row_number() over() as rn,DT.* from DBtable as DT) as a where rn>10 and rn<=20