请教SQL语句错在哪里？？？(页 1) - SQL Server论坛

foshan 发表于 2008-2-20 14:34

请教SQL语句错在哪里？？？

1、执行以下查询语句时出现“在关键字 'Union' 附近有语法错误。”，不知如何更正错误？？？
2、以下查询语句为了实现在最后一行统计  FuKuanJinE 字段之和，请问能否精简一下代码？？
谢谢大家!

select
HeTongXinXi.HeTongID,HeTongBianHao,HeTongMingCheng,YiFangDanWei,convert(varchar(10),FuKuanShiJian,120) as FuKuanShiJian,FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%' order by HeTongBianHao
Union all
select
null as HeTongID,总计 as HeTongBianHao,null as HeTongMingCheng,null as YiFangDanWei,null as FuKuanShiJian,sum(FuKuanJinE) as FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%'

XieLi 发表于 2008-2-21 13:22

不能用ORDER BY

foshan 发表于 2008-2-28 08:57

谢谢!将 ORDER BY 放在最后就可以解决出错的问题了。
select
HeTongXinXi.HeTongID,HeTongBianHao,HeTongMingCheng,YiFangDanWei,convert(varchar(10),FuKuanShiJian,120) as FuKuanShiJian,FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where XiangMuMingChenID like '%1/2/3/11%'
Union all
select
null as HeTongID,总计 as HeTongBianHao,null as HeTongMingCheng,null as YiFangDanWei,null as FuKuanShiJian,sum(FuKuanJinE) as FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where XiangMuMingChenID like '%1/2/3/11%'
order by HeTongBianHao

foshan 发表于 2008-2-28 08:59

还有一个问题：上述语句有很多重复部分，如何将上述的语句精简一下啊？

恋轩念伊人 发表于 2008-3-2 22:26

看的脑袋晕乎乎的

页: [1]