HAVING和WHERE的区别

HAVING短语作用于组,从中选择满足条件的组。   SELECT sno,AVG(grade) FROM student GROUP BY sno HAVING AVG(grade)>=90; WHERE子句作用于基表或视图,从中选择满足条件的元组。   SELECT name,sex,age F...