db2如何獲取1？

假設你的表名字為t1，其中有一個字段為id，你打算按照id的升序排列，依次顯示1-5條、6-10條等SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY id) as r FROM t1) WHERE r BETWEEN 1 AND 5ORDER BY id需要顯示第m到第n條，只需替換BETWEEN和AND后面的數即可。