SQL中如何讓百分比后面保留2位小數(shù)?
例：select str(convert(float,(@czcj/@ckrs)*100))+'%' as 機(jī)試合格率
輸出顯示：87%,但是想要后面保留兩位小數(shù)如：87%.12.
87.12%
declare @ckrs float
declare @czcj float
declare @bscj float
declare @hgrs float
declare @qkrs float
select @ckrs=count(*) from 計(jì)算機(jī)考試成績(jī)201112 where 院系名稱='旅游系'
select @czcj=count(*) from 計(jì)算機(jī)考試成績(jī)201112 where 院系名稱='旅游系' and 操作成績(jī)>='60'
select @bscj=count(*) from 計(jì)算機(jī)考試成績(jī)201112 where 院系名稱='旅游系' and 理論成績(jī)>='60'
select @hgrs=count(*) from 計(jì)算機(jī)考試成績(jī)201112 where 院系名稱='旅游系' and (理論成績(jī)>='60' and 操作成績(jī)>='60')
select @qkrs=count(*) from 計(jì)算機(jī)考試成績(jī)201112 where 院系名稱='旅游系' and (理論成績(jī)='0' and 操作成績(jī)='0')
select str(convert(float,(@czcj/@ckrs)*100))+'%' as 機(jī)試合格率,str(convert(float,(@bscj/@ckrs)*100))+'%' as 筆試通過(guò)率,str(convert(float,(@hgrs/@ckrs)*100))+'%' as 通過(guò)率,str(convert(float,(@qkrs/@ckrs)*100))+'%' as 缺考率