1、使用row_number() over (order by 字段 )
-- 查询第11到20条
SELECT * FROM (SELECT (row_number() OVER (ORDER BY a.AMID)) AS num,* FROM AssetManage a ) x WHERE x.num BETWEEN 11 AND 20;
2、使用 order by offset ~ row fetch next ~ rows only
-- 查询第11到20条(跳过前10条,抓取10条)
SELECT * FROM AssetManage a ORDER BY a.AMID OFFSeT 10 ROW FETCH NEXT 10 ROWS ONLY