Select Max( a.m_jjdc )
from t_sugangsave a left outer join t_donggang_suljung b on b.mid = a.mid And substring( b.code, 11, 2 ) = a.m_jjdc
where a.stu_c = 10006756
Group By a.m_jjdc
Having Max( b.gubun ) <> '2'
Order By m_jjdc

결과가 '29','30' 두개가 나오는데,
둘중에 큰값 하나만 나오게 할수는 없나요?