db2 行数限定选择

1，选择前 100 行

SELECT * FROM TABLE1 FETCH FIRST 100 ROWS ONLY 

 

2，选择n 至 m之间的行（包括n和m行）

select * from (select col1,col2,col3,ROW_NUMBER() OVER (ORDER BY record_id DESC) AS myrank from a) as temptable where myrank beween n and m