结果用小数两位以内百分数显示怎么写呢[/quote]
SELECT 分组,cast(cast(AVG(费用)/(SELECT AVG(费用) FROM #DRG)*100 as decimal(10,2)) as varchar(10))+'%' FROM #DRG GROUP BY 分组[/quote]
老哥,在吗,能说一下嘛[/quote]
你要干啥?
结果用小数两位以内百分数显示怎么写呢[/quote]
SELECT 分组,cast(cast(AVG(费用)/(SELECT AVG(费用) FROM #DRG)*100 as decimal(10,2)) as varchar(10))+'%' FROM #DRG GROUP BY 分组[/quote]
老哥,在吗,能说一下嘛
结果用小数两位以内百分数显示怎么写呢[/quote]
SELECT 分组,cast(cast(AVG(费用)/(SELECT AVG(费用) FROM #DRG)*100 as decimal(10,2)) as varchar(10))+'%' FROM #DRG GROUP BY 分组[/quote]
那个我要把这列结果都相加再列一列在这个查询里怎么弄呢,直接SUM显示错误啊