回答:利用LAG函数返回结果集中先前行的数据,不过你这个数据要先进性分组才行select a字段 , LAG(a字段) OVER (PARTITION BY 分组字段 ORDER BY 序号 ) as 上一行a字段的值 ,a字段 - LAG(a字段) OVER (PARTITION BY 分组字段 ORDER BY 序号 ) as 差值from table
回答:用层次坐标计算,参考:逐层累计-https://help.fanruan.com/finereport/doc-view-348.html
回答:在参数里面添加op=view试试
回答:lydate要不就改成01月,02月这样直接排序
回答:SELECT * FROM 表 where 1=1 and (数据列 in ('${参数1}') or 数据列 in ('${参数2}'))
回答://先找到报表块,然后添加JS脚本:setTimeout(function() { //隐藏报表块report9_c的滚动条(此报表块名为report9_c,根据具体情况修改,要大写) $("div").find(".frozen-north").css({ 'overflow-x':'hidden', 'overflow-y':'hidden' }); $("div").find(".frozen-center").css({ 'overflow-x':'hidden', 'overflow-y':'hidden' }); },1000); window.flag = true; //鼠标悬停,滚动停止 setTimeout(function() { $(".frozen-center").mouseover(function() { window.flag = false; }); //鼠标离开,继续滚动 $(".frozen-center").mouseleave(function() { window.flag = true; }); var old = -1; // 清除定时器 if(window.tag!=null){ window.clearInterval(window.tag); } window.tag=setInterval(function() { if(window.flag) { currentpos = $(".frozen-center").scrollTop; if(currentpos == old) { $(".frozen-center").scrollTop = 0; } else { old = currentpos; //以25ms的速度每次滚动1.5PX $(".frozen-center").scrollTop = currentpos + 1; var speed = currentpos + 1; } } }, 65); }, 1000);
回答:select 月份, count(*) as 订单数量, sum(销量) as 月销售量from 表 group by 月份
回答:递归生成日期:declare @dt1 datedeclare @dt2 dateselect max(日期) = @dt1 from 工序表set @dt2 = GETDATE();WITH datesas(select @dt1 as dtunion allselect dateadd(day, 1, T1.dt) as dt from dates T1where 1=1and T1.dt < @dt2)SELECT * from dates,工序表
8
8
0
10
没有更多