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)
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)
本文标题:view 视图
本文链接:https://www.haomeiwen.com/subject/ejokmxtx.html
网友评论