例1:单数据集联合查询行式分页报表()
定义分页查询SQL
SELECT *
FROM (
SELECT TOP ${
if(fr_pagenumber == int((((fr_rowcount-1)/fr_pagesize)+1)),fr_rowcount - (fr_pagesize*(fr_pagenumber-1)),fr_pagesize)
} *
FROM(
SELECT TOP ${fr_pagesize*fr_pagenumber} a.dudao,b.dpmc ,sum(sl*sj) je
FROM kehu a
join sale b on a.khmc=b.dpmc
where a.dudao='${dudao}'//条件可添加在此处
group by a.dudao,b.dpmc
) AS e1 ORDER BY dudao DESC
) AS e2 ORDER BY dudao ASC
例2:SQL视图分页转至(http://help.finereport.com/doc-view-996.html)
- with t_rowtable
- as
- (
- select row_number() over(order by object_id DESC) as row_number,* from sys.[all_columns] where 1=1
- )
- SELECT *
- FROM (
- SELECT TOP ${
- if(fr_pagenumber == int((((fr_rowcount-1)/6)+1)),fr_rowcount - (6*(fr_pagenumber-1)),6)
- } *
- FROM(
- SELECT TOP ${6*fr_pagenumber} *
- FROM t_rowtable ORDER BY row_number ASC
- ) AS e1 ORDER BY row_number DESC
- ) AS e2 ORDER BY row_number ASC