表 magazine,有一字段 earning 年收入 ,要查出 字段里相同记录各有多少条,以及 相应 的占多少百分比。select earning,count(earning) as cot from magazine group by earning这个是上面那个图的SQL语句,百分比 不知道该怎么写 。我试过一些方法都不行
问题我已经解决了,select earning,count(earning) as cot ,round((count(earning)/ (select count(id) from magazine))*100,2)+'%' as percent from magazine group by earning
(select count(id) from magazine))*100,2)+'%' as percent
from magazine group by earning