select ' '
+cast(cast( as decimal(18,1)) as varchar(20))
+''
+ case when a.同比>= 0 THEN '+'+cast(cast(a.同比*100 as decimal(18,1)) as varchar(20))
when a.同比< 0 THEN cast(cast(a.同比*100 as decimal(18,1)) as varchar(20))
end
+'%' as
from ( ) a
SQL server列转行
最新推荐文章于 2024-06-14 10:14:22 发布