6个回答
缱绻 发表于 2019-4-26 16:25
勾选指标就可以写单独的过滤条件了
select row_.*,rownum from ( select a.B7 as B7,a.C7 as C7,a.D7 as D7,a.E7 as E7,b.I7 as I7,b.J7 as J7,b.N7 as N7,b.Q7 as Q7,c.R7 as R7,a.A7 as A7
from (
select max(a.AGENCY_TYPECODE) as B7,sum(a.MENBERLX) as C7,sum(a.MENBERLX) as D7,sum(a.MENBERLX) as E7,a.UNITNAME as A7
from VW_BG_WORKMEMBER_EN a
group by a.UNITNAME) a
,(
select sum(a.POSTWAGE) as I7,sum(a.LEVELWAGE) as J7,sum(a.WORKALLOWANCE) as N7,sum(a.SINGLECHILDALLOWANCE) as Q7,a.UNITNAME as A7
from VW_BG_WORKMEMBER_EN a
where (a.AGENCY_TYPECODE LIKE '001%')
group by a.UNITNAME) b
,(
select sum(a.POSTWAGE) as R7,a.UNITNAME as A7
from VW_BG_WORKMEMBER_EN a
where (a.AGENCY_TYPECODE LIKE '002%')
group by a.UNITNAME) c
where ((a.A7=b.A7)) and ((a.A7=c.A7)) )row_ where rownum <= 1000
这样不行啊
彭娟 发表于 2019-4-26 17:47
select row_.*,rownum from ( select a.B7 as B7,a.C7 as C7,a.D7 as D7,a.E7 as E7,b.I7 as I7,b.J7 as ...
算不出来，你看这样产生的sql中有一个where条件，然后查不出来
彭娟 发表于 2019-4-26 17:49
算不出来，你看这样产生的sql中有一个where条件，然后查不出来
是什么查不出来？？是想实现什么样的效果呢？
缱绻 发表于 2019-4-26 17:59
是什么查不出来？？是想实现什么样的效果呢？
一个浮动分析表，其中俩个字段需要做一个筛选，
比如我做一张所有单位工资表，报表表头分有行政和事业单位，然后事业单位金额和行政单位金额需要判断该单位性质过滤
