本文介绍了在sql server中显示sql查询结果集的%符号的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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查询结果集的%符号
发布评论