db2每次查询一定条数数据-模拟limit语法

可以使用FETCH FIRST 10 ROWS ONLY子句代替LIMIT

代替LIMIT和OFFSET，您应该能够将ROW_NUMBER

SELECT emp.EMPNO, emp.SALARY
 FROM (

     SELECT EMPNO, SALARY, 
            ROW_NUMBER() OVER(ORDER BY SALARY DESC) as row_number
     FROM EMPLOYEE

 ) emp
 WHERE emp.row_number > 10
 AND emp.row_number <= 20