摘要:
--33.查询成绩比该课程平均成绩低的同学的成绩表。 select degree from score s join (select avg(degree) as d from score a group by cno)a on s.cno=a.cno and s.degree1 ; --37、查询Student表中不姓“王”的同学记 select * from student where... 阅读全文
摘要:
create table Student ( Sno VARCHAR2(3) not null, Sname VARCHAR2(8) not null, Ssex NUMBER(2) not null, Sbirthday date not null, SClass number(5) ); comment on column Stu... 阅读全文