日期:2014-05-18 浏览次数:20519 次
select a.sceneId, ltrim(cast(sum(b.ApplyAdult)*100./nullif(sum(AppluNumber),0) as decimal(12,2)))+'%' Adult from SceneInfo a join ApplyInfo b on a.sceneId = b.sceneId group by a.sceneId -- ???