select cno, avg(final)
from enrol
group by cno
having avg(final) >= all(select temp.avgval
from(select cno, avg(final)
from enrol
group by cno) as temp(cno,avgval));
에러 :
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(cno,avgval)) LIMIT 0, 30' at line 7
이런 에러가 발생합니다.. 도저히 이유를 모르겠어요ㅠㅠㅠㅠㅠㅠㅠㅠㅠㅠ
|