34,593
社区成员
发帖
与我相关
我的任务
分享
select 装车人,
总装车费,
装车人数,
平均装车费= 总装车费/装车人数
from
(
SELECT [LoadingOne] as 装车人
,总装车费=dbo.zxhuo(KaName,Brand,1,GoodsTon,0,0),
装车人数=dbo.CreateListFromStr(LoadingOne)
where.....
)t
with t as
(SELECT [LoadingOne] as 装车人,
总装车费=dbo.zxhuo(KaName,Brand,1,GoodsTon,0,0),
装车人数=dbo.CreateListFromStr(LoadingOne)
from [表名]
where.....
)
select 装车人,总装车费,装车人数,平均装车费=总装车费/装车人数 from t