Group by 的应用
SELECT SUM(gasNumber)FROM wxbs_excel GROUP BY IDNumber
Group by 于having 结合应用
SELECT IDNumber FROM wxbs_excel GROUP BY IDNumber HAVING SUM(gasNumber)>20;
执行过程
from->where->group by->having->select->order by
Group by 的应用
SELECT SUM(gasNumber)FROM wxbs_excel GROUP BY IDNumber
Group by 于having 结合应用
SELECT IDNumber FROM wxbs_excel GROUP BY IDNumber HAVING SUM(gasNumber)>20;
执行过程
from->where->group by->having->select->order by