{"title":"分页查询","inframe":false,"hidden":false,"roles":{"demo":1,"dev":1},"pageLink":"","children":[{"configs":{"itemId":"module"},"children":[{"configs":{"postgresql":"select * from WB_PAGING limit {?bigint.limit?} offset {?bigint.start?}","sqlserver":"select * from (\n  select row_number() over (order by V) as \"RN\", * from WB_PAGING\n) t1\nwhere RN between {?bigint.beginIndex?} and {?bigint.endIndex?}","db2":"select * from (\n  select rownumber() over (order by V) as \"RN\", t1.* from WB_PAGING t1\n) t2\nwhere RN between {?bigint.beginIndex?} and {?bigint.endIndex?}","itemId":"select","oracle":"select * from (\n  select t1.*, ROWNUM as \"RN\" from WB_PAGING t1 where ROWNUM<={?bigint.endIndex?}\n)\nwhere RN >= {?bigint.beginIndex?}","mysql":"select * from WB_PAGING limit {?bigint.start?},{?bigint.limit?}\n-- start序号从0开始"},"children":[],"type":"sqlswitcher","expanded":false},{"configs":{"autoPage":"false","sql":"{#select#}","totalSql":"select count(*) from WB_PAGING","itemId":"dataprovider1"},"children":[],"type":"dataprovider","expanded":false}],"type":"module","expanded":true}],"iconCls":""}