DBMS/Summary

이중쿼리 문...

gandus 2010. 4. 5. 21:15


select*from grade  where kor <  (select avg(kor)from grade);                     
//  국어 평균 낮은사람

select*from grade where (kor+math+eng) /3 >= (select avg( kor+math+eng  )/3 from grade);  
// 평균보다 높거나 같은사람