order by 有点问题:select Item,totalintoqut from ( 你的那些语句,除了order by item ) a order by a.Item感觉其他的应该没问题
select item,sum(orderpacks) as totalorderpacks,sum(realpacks) as totalrealpacks, sum(amount) as totalamount,sum(costamount) as totalcostamount from (select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks, sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount, item = case when (item like '% toilet cleaner %') then 'TC' else '' end from export where item like '% toilet cleaner %' group by itemunion select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks, sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount, item= case when (item like '% wet flooring %') then 'WF' else '' end from export where item like '% wet flooring %' group by item union select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks, sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount, item= case when (item like '% dry flooring %') then 'DF' else '' end from export where item like '% dry flooring %' group by item ) a group by item共享。谢谢大家的回复,很感谢!
(
你的那些语句,除了order by item
) a
order by a.Item感觉其他的应该没问题
sum(amount) as totalamount,sum(costamount) as totalcostamount from
(select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks,
sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount,
item = case when (item like '% toilet cleaner %') then 'TC' else '' end
from export where item like '% toilet cleaner %' group by itemunion
select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks,
sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount,
item= case when (item like '% wet flooring %') then 'WF' else '' end
from export where item like '% wet flooring %' group by item union
select sum(isnull(orderpacks,0)) as orderpacks ,sum(isnull(realpacks,0)) as realpacks,
sum(isnull(amount,0)) as amount,sum(isnull(costamount,0)) as costamount,
item= case when (item like '% dry flooring %') then 'DF' else '' end
from export where item like '% dry flooring %' group by item ) a group by item共享。谢谢大家的回复,很感谢!