view 视图

CREATE VIEW v_grad

as

select sno,cno,degree

from scorce s

where  degree=(SELECT max(degree)

from  scorce s2

where s.cno=s2.cno)