use pubsgoselect rtrim(cast( (cast(min_lvl as decimal(10,4))/(select sum(min_lvl) from jobs))*100 as decimal(5,2))) '%' as '百分数（%）'from jobs......
use pubs
go
select rtrim(cast(
(cast(min_lvl as decimal(10,4))/(select sum(min_lvl) from jobs))*100 as decimal(5,2))) '%' as '百分数（%）'
from jobs
|
