想要舍入到2位小数,但得到更多小数位 [英] Want to round off to 2 decimal places but getting more decimal places
本文介绍了想要舍入到2位小数,但得到更多小数位的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT A.BRNNAME,A.SCORE,COALESCE(A.Q1Y1C,0)Q1Y1C,COALESCE(C.Q1Y2C,0)Q1Y2C,
COALESCE(A.Q2Y1C,0) Q2Y1C,COALESCE(C.Q2Y2C,0)Q2Y2C,
COALESCE(A.Q3Y1C,0)Q3Y1C,COALESCE(C.Q3Y2C,0)Q3Y2C,
COALESCE(A.Q4Y1C,0)Q4Y1C, COALESCE(C.Q4Y2C,0)Q4Y2C,
ROUND(COALESCE(B.Q1Y1P,0.00),2)Q1Y1P,COALESCE(ROUND(D.Q1Y2P,2),0.00)Q1Y2P,
COALESCE( ROUND(B.Q2Y1P,2),0.00)Q2Y1P,COALESCE(ROUND(D.Q2Y2P,2),0.00)Q2Y2P,
COALESCE(ROUND(B.Q3Y1P,2),0.00)Q3Y1P,COALESCE(ROUND) (D.Q3Y2P,2),0.00)Q3Y2P,
COALESCE(ROUND(B.Q4Y1P,2),0.00)Q4Y1P,COALESCE(ROUND(D.Q4Y2P,2),0.00)Q4Y2P
FROM Y1C A
INNER JOIN Y1P B ON A.BRNNAME = B.BRNNAME AND A.SCORE = B.SCORE
INNER JOIN Y2C C ON A.BRNNAME = C.BRN NAME AND A.SCORE = C.SCORE
INNER JOIN Y2P D ON A.BRNNAME = D.BRNNAME AND A.SCORE = D.SCORE
ORDER BY A.BRNNAME
< b>
我尝试过:
正在构建的代码尝试了以下但不能正常工作
解决方案
cast(Round((ColumanName),2)as decimal(18,2))as [Name]
SELECT A.BRNNAME,A.SCORE , COALESCE(A.Q1Y1C, 0) Q1Y1C , COALESCE(C.Q1Y2C, 0) Q1Y2C , COALESCE(A.Q2Y1C, 0) Q2Y1C , COALESCE(C.Q2Y2C, 0) Q2Y2C , COALESCE(A.Q3Y1C, 0) Q3Y1C , COALESCE(C.Q3Y2C, 0) Q3Y2C , COALESCE(A.Q4Y1C, 0) Q4Y1C , COALESCE(C.Q4Y2C, 0) Q4Y2C , ROUND(COALESCE(B.Q1Y1P, 0.00),2) Q1Y1P , COALESCE(ROUND(D.Q1Y2P,2), 0.00) Q1Y2P , COALESCE(ROUND(B.Q2Y1P,2), 0.00) Q2Y1P , COALESCE(ROUND(D.Q2Y2P,2), 0.00) Q2Y2P , COALESCE(ROUND(B.Q3Y1P,2), 0.00) Q3Y1P , COALESCE(ROUND(D.Q3Y2P,2), 0.00) Q3Y2P , COALESCE(ROUND(B.Q4Y1P,2), 0.00) Q4Y1P , COALESCE(ROUND(D.Q4Y2P,2), 0.00) Q4Y2P FROM Y1C A INNER JOIN Y1P B ON A.BRNNAME=B.BRNNAME AND A.SCORE=B.SCORE INNER JOIN Y2C C ON A.BRNNAME=C.BRNNAME AND A.SCORE=C.SCORE INNER JOIN Y2P D ON A.BRNNAME=D.BRNNAME AND A.SCORE=D.SCORE ORDER BY A.BRNNAME
What I have tried:
Codes under construction tried the following but not working
解决方案
cast(Round((ColumanName),2) as decimal(18,2)) as [Name]
这篇关于想要舍入到2位小数,但得到更多小数位的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文