我有以下两个代码,我需要通过将“ for_2018_19”除以“总计”来获得百分比。我不知道如何合并它们并获得单个结果,即百分比。
select sum(maternities) as total from merged
where City = 'Jeza' and Group = 'Unknown';
select sum(Maternities) as for_2018_19 from merged
where Year = '2016/17') percentage ;
您可以使用bth查询作为唯一返回单个数据的子查询
但是您应该记住组是保留字,您应该避免使用它
SELECT
(select sum(maternities) from merged
where City = 'Jeza' and `Group` = 'Unknown')/
(select sum(Maternities) from merged
where Year = '2016/17') as percentage
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句