Student表: stu_id (id) stu_credit (分) dept_id (部门) Department表: dept_id (部门) dept_name (部门名称)select a.dept_name , max(b.stu_credit) stu_credit from Department a, Student b where a.dept_id = b.dept_id group by a.dept_name
select d.dept_name , max(s.stu_credit) from Department d, Student s where d.dept_id = s.dept_id group by d.dept_id
stu_credit (分)
dept_id (部门)
Department表: dept_id (部门)
dept_name (部门名称)select a.dept_name , max(b.stu_credit) stu_credit
from Department a, Student b
where a.dept_id = b.dept_id
group by a.dept_name
from Department d, Student s
where d.dept_id = s.dept_id
group by d.dept_id