山东大学数据库实验4答案.docVIP

  • 20
  • 0
  • 约5.27千字
  • 约 9页
  • 2017-12-22 发布于河南
  • 举报
山东大学数据库实验4答案

山东大学数据库实验4答案 update dbtest set test=4 select * from dbscore 实验一: create table test4_01 as ( select * from pub.student_41 ) alter table test4_01 add sum_score decimal alter table test4_01 add avg_score decimal(4,1) alter table test4_01 add sum_credit decimal alter table test4_01 add did varchar(2) update test4_01 set sum_score = ( select sum(a.score) from pub.student_course a,pub.course b where a.cid=b.cid and a.sid=test4_01.sid group by a.sid ) 实验二 create table test4_02 as ( select * from pub.student_41 ) alter table test4_02 add sum_score decimal alter table test4_02 add avg_score decimal(4,1

文档评论(0)

1亿VIP精品文档

相关文档