SQL百分比

百分比=cast(cast(count(ProvinceName)*100./

(select count(Id) from 

dbo.TopicCurrent 

 where boardId=316 and Status=1

)as  decimal(10,2))   as   varchar)+'%'