为Set for Set查询设置的ireport quires？ [英] ireport quires set for the SQL for Set query?

问题描述

我正在尝试获取Ireport的等效查询。
这是我的SQL查询。
但是当我将它粘贴到Ireport数据集时，我收到此错误。

I am trying to get equivalent query for the Ireport. this is my sql query. but when I am pasting it to Ireport dataset i am getting this error.

set @csum := 0;
set @csum1 := 0;
select SUM,(@csum := @csum + Profit_Total) as Cumulative,
Sum(profit) as Profit_Total
from table t1;

推荐答案

你可以尝试这种方式，首先尝试设置内部select语句中的变量然后你可以在外部select语句中总结： -

You can try in this way, first try to set the variables in inner select statement then you can sum up in the outer select statement :-

    SELECT SUM(@csum := @csum + Profit_Total)
    FROM (SELECT profit, @csum := 0
          FROM  t1) a;

这篇关于为Set for Set查询设置的ireport quires？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！