DB2分页查询SQL

最新推荐文章于 2021-06-29 17:35:29 发布

weixin_33770878

最新推荐文章于 2021-06-29 17:35:29 发布

阅读量1.2k

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/ruanjianxian/p/6126924.html

版权

select * from
(select row_number() over() as rown,tpag.* from(SELECT int(COALESCE(列名1,0)),COALESCE(列名2,chr(0)),COALESCE(列名3,chr(0)),COALESCE(列名4,0), COALESCE(列名5,0),COALESCE(列名6,0)
FROM 表名 where 列名7=条件 and 列名8=1 and 列名9=0 order by 列名10)

tpag fetch first 20000 rows only) tt where tt.rown between 1 and 20;

fetch first 20000 rows only防止过多占用资源。

转载于:https://www.cnblogs.com/ruanjianxian/p/6126924.html