在sql server中显示sql查询结果集的％符号 [英] Display % symbol to result set of sql query in sql server

问题描述

select EName,Basic,PF,PF/Basic*100 as [PF Percentage] from Emp where EName='John'

结果：

Result :

EName    Basic   PF      PF Percentage
John     1000    100         10

但我想要显示

But I want to display

PF Percentage
   10 %

可以我写了

Can i write

select EName,Basic,PF,PF/Basic*100+'%' as [PF Percentage] from Emp where EName='John'

谢谢

Thanks

推荐答案

试试这个

hi ,

try this

Select EName,Basic,PF,CAST(PF/Basic*100 as varchar(20)) + '%' as [PF Percentage] from Emp where EName='John'

select convert(varchar(10), PF/basic * 100) + '%' as [PF Percentage] from applicationInfo

在此之前你必须将你的专栏投射到角色，试试这样

你可以设置varchar limt根据您的需要，

Before that you have to cast your column to character,try like this
you can set varchar limt as per your needs,

select EName,Basic,PF,cast(PF/Basic*100 as varchar(50))+'%' as PF_Percentage from Emp where EName='John'

这篇关于在sql server中显示sql查询结果集的％符号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！