如何在sql server中获取Percentage值 [英] How to get Percentage value in sql server
本文介绍了如何在sql server中获取Percentage值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一张像这张桌子的桌子1
sno value1 value2
1 10000 11500
2 12000 13500
现在我需要写这样的查询
选择 value1,value2,cast(((value1-value2)/ value2)* 100 as float ) as Value3 来自 table1
i写得像这样,但我得到的输出像
< pre lang =SQL> value1 value2 value3
10000 11500 0
但是在value3列中,我需要得到像 98 。 2 , 95 。 3
我怎样才能得到它?请任何人帮帮我。解决方案把它投成十进制(5,2)
声明
@ v1十进制(10,2),
@ v2十进制(10,2)
设置@ v1 = 10000
设置@ v2 = 13500
选择@ v1,@ v2,cast(((@ v1- @ v2)/ @ v2)* 100为十进制(5,2))
10000.00
13500.00
-25.93
>
检查这个...
选择
value1,
value2,
(( CONVERT ( DECIMAL ( 10 , 2 ),VALUE1) - CONVERT ( DECIMAL ( 10 , 2 ),VALUE2))/( CONVERT ( DECIMAL ( 10 , 2 ),VALUE2)))* 100 VALUE3
来自 table1
希望这会对你有所帮助。
干杯
i have one table like this table1
sno value1 value2
1 10000 11500
2 12000 13500
now i need to write query like this
select value1,value2,cast(((value1-value2)/value2)*100 as float) as Value3 from table1
i wrote like this but i am getting output like
value1 value2 value3
10000 11500 0
12000 13500 0
but in value3 column, i need to get values like
98.2,95.3
How can i get it? Please any one help me.
解决方案
Cast it as decimal(5,2)
declare @v1 decimal(10,2), @v2 decimal(10,2) set @v1 = 10000 set @v2 = 13500 select @v1 ,@v2 ,cast(((@v1-@v2)/@v2)*100 as decimal(5,2))
10000.00
13500.00
-25.93
Hi,
Check this...
Select value1, value2, ((CONVERT(DECIMAL(10,2),VALUE1) - CONVERT(DECIMAL(10,2),VALUE2)) / (CONVERT(DECIMAL(10,2),VALUE2)))*100 as VALUE3 from table1
Hope this will help you.
Cheers
这篇关于如何在sql server中获取Percentage值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文