34,590
社区成员
发帖
与我相关
我的任务
分享
select 进价, 售价, (convert(varchar(5),(售价-进价)*100/售价) + '%') as 毛利
from tablename
declare @tableName table
(
进价 float,
售价 float
)
insert into @tableName values(8,10)
insert into @tableName values(5.8,8.2)
select 进价,售价,cast(round((售价-进价)/售价*100,1) as varchar(100))+'%' as 毛利 from @tableName