select household,COUNT(*),(COUNT(*))/(select COUNT(*) from finalcampaign) *100 as Higndecimal from finalcampaign group by household;
失败:parseexception行1:37无法识别表达式规范中“select”“count”()附近的输入
xwmevbvl1#
您可以使用如下表别名进行尝试:
select household, COUNT(*), 100*(COUNT(*))/B.CNT from finalcampaign , (select COUNT(*) as CNT from finalcampaign) As B group by household,B.CNT;
1条答案
按热度按时间xwmevbvl1#
您可以使用如下表别名进行尝试: