回答:CreatedOn>=concat('${starttime}',' 00:00') and CreatedOn<=concat('${starttime}',' 23:59')
回答:使用label存储了数据工厂信息,在数据查询时获取label的信息
回答:模板-页面设置 ,纸张大小,自定义X改大点就行
回答:用ROW_NUMBER()就行select * from ( select t.* ,ROW_NUMBER() over (PARTITION BY t.zzyslxm ORDER by t.b )as num from (select zzyslxm,hkxmmc,sum(hksl)as a,sum(hkxj)as b from sap.v_hub_dwd_confirmation group by zzyslxm,hkxmmc order by sum(hkxj)) t ) d where d.num <=10
4
4
1
10
没有更多