立即学习:https://edu.csdn.net/course/play/31333/468092?utm_source=blogtoedu
count(8)加在select和from之间,代表计算该行数据出现到次数;
例:select name,count(*) as count from....
having是对结果查询,where是对from后面对值进行查询
立即学习:https://edu.csdn.net/course/play/31333/468092?utm_source=blogtoedu
count(8)加在select和from之间,代表计算该行数据出现到次数;
例:select name,count(*) as count from....
having是对结果查询,where是对from后面对值进行查询