帮忙写SQL语句,谢谢了

[dengyi425]

SQL 中如何计算50/100 等于50%呀!我要实现这样子的怎么弄?

[hongqi162]

cast(cast(分子*1.0*100/分母 as decimal(10,2)) as varchar(50)) +'%'

[skyaspnet]

[Quote=引用 1 楼 hongqi162 的回复:]
cast(cast(分子*1.0*100/分母 as decimal(10,2)) as varchar(50)) +'%'
[/Quote]

[宝_爸]

[Quote=引用 1 楼 hongqi162 的回复:]
cast(cast(分子*1.0*100/分母 as decimal(10,2)) as varchar(50)) +'%'
[/Quote]

[JeffChung]

[Quote=引用 1 楼 hongqi162 的回复:]
cast(cast(分子*1.0*100/分母 as decimal(10,2)) as varchar(50)) +'%'
[/Quote]