select left([CardNum],3)as 卡类别,round(sum (TotalMoney)/10000,2) as '消费金额(万元)'
FROM [Analyze_db].[dbo].[date_VipList]
where date between '2014-01-01' and '2014-12-31'
group by left([CardNum],3)
执行结果如何去掉多余的“0”
...全文
882打赏收藏
字段保留2位有效数字
如何将T-SQL执行结果的 ,“消费金额”字段 实际保留2位有效数字。烦请前辈指教 select left([CardNum],3)as 卡类别,round(sum (TotalMoney)/10000,2) as '消费金额(万元)' FROM [Analyze_db].[dbo].[date_VipList] where date between '2014-01-01' and '2014-12-31' group by left([CardNum],3) 执行结果如何去掉多余的“0”
select left([CardNum],3)as 卡类别,CAST (sum (TotalMoney)/10000 AS DECIMAL(18,2)) as '消费金额(万元)'
FROM [Analyze_db].[dbo].[date_VipList]
where date between '2014-01-01' and '2014-12-31'
group by left([CardNum],3)