select v_ytj.byfcje,v_ytj.pzbh,ytj.fcje,ytj.pzbh
from dbo.v_ytj left join (select pzbh,sum(sl*pjdj) as fcje
from clkj.sccb
where year=2006 and month=10 and cklx="007002"
group by pzbh ) as ytj on (v_ytj.pzbh=ytj.pzbh)
where v_ytj.cklx="007002" and v_ytj.year=2006 and v_ytj.month=10 and v_ytj.byfcje<>ytj.fcje;
怎么可以截取ytj中fcje计算列的数值保持小数点后两位。原来pjdj字段小数点后有3位。谢谢!
from dbo.v_ytj left join (select pzbh,sum(sl*pjdj) as fcje
from clkj.sccb
where year=2006 and month=10 and cklx="007002"
group by pzbh ) as ytj on (v_ytj.pzbh=ytj.pzbh)
where v_ytj.cklx="007002" and v_ytj.year=2006 and v_ytj.month=10 and v_ytj.byfcje<>ytj.fcje;
怎么可以截取ytj中fcje计算列的数值保持小数点后两位。原来pjdj字段小数点后有3位。谢谢!
解决方案 »
- 求解在将 varchar 值 'fetch next from deletemonth into ' 转换成数据类型 int 时失败。
- sql中字符串中含有数字时的逆序排序方法,如何让a10在a9前面?
- 有1000条记录,某个字段从1到1000,里面缺几条,怎么把这几条找出来?
- 跪求 关于两个表之间操作的SQL 语句
- 求Money 型数据相加的 update 语句..
- 两个表合并,值相加问题
- 如何读取远程机器的数据!
- sql server2008输出的XML文件如何保存成UTF-8的编码格式?
- 麻烦高手们来帮忙解释这些代码,,不胜感激~~~!
- 查询问题.关于sql关联查询。谢谢
- 新手上路,求一条SQL,先谢谢了!
- 我想在本机上设置sql邮件服务,可以绕开exchange server么?
--显形指定
select v_ytj.byfcje,v_ytj.pzbh,cast(ytj.fcje as decimal(9,3)),ytj.pzbh
from dbo.v_ytj left join (select pzbh,sum(sl*pjdj) as fcje
from clkj.sccb
where year=2006 and month=10 and cklx="007002"
group by pzbh ) as ytj on (v_ytj.pzbh=ytj.pzbh)
where v_ytj.cklx="007002" and v_ytj.year=2006 and v_ytj.month=10 and v_ytj.byfcje<>ytj.fcje;
from dbo.v_ytj left join (select pzbh,sum(sl*pjdj) as fcje
from clkj.sccb
where year=2006 and month=10 and cklx="007002"
group by pzbh ) as ytj on (v_ytj.pzbh=ytj.pzbh)
where v_ytj.cklx="007002" and v_ytj.year=2006 and v_ytj.month=10 and v_ytj.byfcje<>ytj.fcje;
select left(round(sum(sl*pjdj),2),len(sum(sl*pjdj))-1) as fcje
截断的
select left(round(sum(sl*pjdj),2),len(sum(sl*pjdj))-1,1) as fcje