SQL中如何让百分比后面保留2位小数?例:select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率输出显示:87%,但是想要后面保留两位小数如:87%.12.87.12%declare @ckrs floatdeclare @czcj floatdeclare @bscj floa
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/07 11:41:24
![SQL中如何让百分比后面保留2位小数?例:select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率输出显示:87%,但是想要后面保留两位小数如:87%.12.87.12%declare @ckrs floatdeclare @czcj floatdeclare @bscj floa](/uploads/image/z/8819533-37-3.jpg?t=SQL%E4%B8%AD%E5%A6%82%E4%BD%95%E8%AE%A9%E7%99%BE%E5%88%86%E6%AF%94%E5%90%8E%E9%9D%A2%E4%BF%9D%E7%95%992%E4%BD%8D%E5%B0%8F%E6%95%B0%3F%E4%BE%8B%EF%BC%9Aselect+str%28convert%28float%2C%28%40czcj%2F%40ckrs%29%2A100%29%29%2B%27%25%27+as+%E6%9C%BA%E8%AF%95%E5%90%88%E6%A0%BC%E7%8E%87%E8%BE%93%E5%87%BA%E6%98%BE%E7%A4%BA%EF%BC%9A87%25%2C%E4%BD%86%E6%98%AF%E6%83%B3%E8%A6%81%E5%90%8E%E9%9D%A2%E4%BF%9D%E7%95%99%E4%B8%A4%E4%BD%8D%E5%B0%8F%E6%95%B0%E5%A6%82%EF%BC%9A87%25.12.87.12%25declare+%40ckrs+floatdeclare+%40czcj+floatdeclare+%40bscj+floa)
SQL中如何让百分比后面保留2位小数?例:select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率输出显示:87%,但是想要后面保留两位小数如:87%.12.87.12%declare @ckrs floatdeclare @czcj floatdeclare @bscj floa
SQL中如何让百分比后面保留2位小数?
例:select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率
输出显示:87%,但是想要后面保留两位小数如:87%.12.
87.12%
declare @ckrs float
declare @czcj float
declare @bscj float
declare @hgrs float
declare @qkrs float
select @ckrs=count(*) from 计算机考试成绩201112 where 院系名称='旅游系'
select @czcj=count(*) from 计算机考试成绩201112 where 院系名称='旅游系' and 操作成绩>='60'
select @bscj=count(*) from 计算机考试成绩201112 where 院系名称='旅游系' and 理论成绩>='60'
select @hgrs=count(*) from 计算机考试成绩201112 where 院系名称='旅游系' and (理论成绩>='60' and 操作成绩>='60')
select @qkrs=count(*) from 计算机考试成绩201112 where 院系名称='旅游系' and (理论成绩='0' and 操作成绩='0')
select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率,str(convert(float,(@bscj/@ckrs)*100))+'%' as 笔试通过率,str(convert(float,(@hgrs/@ckrs)*100))+'%' as 通过率,str(convert(float,(@qkrs/@ckrs)*100))+'%' as 缺考率
SQL中如何让百分比后面保留2位小数?例:select str(convert(float,(@czcj/@ckrs)*100))+'%' as 机试合格率输出显示:87%,但是想要后面保留两位小数如:87%.12.87.12%declare @ckrs floatdeclare @czcj floatdeclare @bscj floa
sqlserver:
select str((convert(float,(@czcj/@ckrs)*100)),5,2)+'%'
或者
select convert(varchar,convert(decimal(10,2),(@czcj/@ckrs)*100))+'%'