各位.帮帮忙!我能不能先排序再用union 连接??/

[jackyhyoung]

是这样的.
我想在数据的最后一行多加一行总和数据,
就写了如下数据.

(select a.ID,a.pj_cd,a.pj_date,isnull(a.SBU,'') SBU,a.pj_Name,b.USER_NAME ucName,isnull(a.FeCurrency,0) Fecurrency,isnull(a.ReCurrency,0) Recurrency,a.Remark from m_order a left join sys_user b on a.user_Cd=b.user_cd order by a.pj_cd Asc )
union
(select '' as id,'' as pj_cd,'3000-12-12' as pj_date,'' as SBU,'Total:' as pj_Name,'' as UcName,sum(isnull(FeCurrency,0)) as Fecurrency,Sum(isnull(ReCurrency,0)) as Recurrency,'' as Remark from m_order)

但说是order 那里出错.
把order by a.pj_cd asc就可以了.但是不能排序,能不能在实现排序的时候也可以在最后一行加上总和的一行啊..各位帮我啊..急!

[OracleRoob]

加上top 100 percent 试试

(select top 100 percent a.ID,a.pj_cd,a.pj_date,isnull(a.SBU,'') SBU,a.pj_Name,b.USER_NAME ucName,isnull(a.FeCurrency,0) Fecurrency,isnull(a.ReCurrency,0) Recurrency,a.Remark from m_order a left join sys_user b on a.user_Cd=b.user_cd order by a.pj_cd Asc )
union
(select '' as id,'' as pj_cd,'3000-12-12' as pj_date,'' as SBU,'Total:' as pj_Name,'' as UcName,sum(isnull(FeCurrency,0)) as Fecurrency,Sum(isnull(ReCurrency,0)) as Recurrency,'' as Remark from m_order)

[-狙击手-]

select a.ID,a.pj_cd,a.pj_date,isnull(a.SBU,'') SBU,a.pj_Name,b.USER_NAME ucName,isnull(a.FeCurrency,0) Fecurrency,isnull(a.ReCurrency,0) Recurrency,a.Remark into #temp from m_order a left join sys_user b on a.user_Cd=b.user_cd order by a.pj_cd Asc


(select * from #temp )
union
(select '' as id,'' as pj_cd,'3000-12-12' as pj_date,'' as SBU,'Total:' as pj_Name,'' as UcName,sum(isnull(FeCurrency,0)) as Fecurrency,Sum(isnull(ReCurrency,0)) as Recurrency,'' as Remark from m_order)

drop table #temp

[zsyp]

order不能放到一个查询当中,如果真想放给你个思路
(Select * from
(select a.ID,a.pj_cd,a.pj_date,isnull(a.SBU,'') SBU,a.pj_Name,b.USER_NAME ucName,isnull(a.FeCurrency,0) Fecurrency,isnull(a.ReCurrency,0) Recurrency,a.Remark from m_order a left join sys_user b on a.user_Cd=b.user_cd order by a.pj_cd Asc ))
union
(select '' as id,'' as pj_cd,'3000-12-12' as pj_date,'' as SBU,'Total:' as pj_Name,'' as UcName,sum(isnull(FeCurrency,0)) as Fecurrency,Sum(isnull(ReCurrency,0)) as Recurrency,'' as Remark from m_order)
这回你再试试