數(shù)據(jù)庫技術與應用復習資料(參考版)
2025-04-20 01:14本頁面
【正文】 GOSELECT * FROM teacher。WHERE teacherno=39。UPDATE v_teacherSET prof=39。語句已終止。計算機學院39。講師39。計算機應用39。張馨月39。0503939。FROM student JOIN scoreON =GROUP BY ,snameORDER BY avg(final)GOSELECT * FROM v_avgstu3. 通過視圖v_teacher向基表teacher中分別插入數(shù)據(jù)(‘05039’, ‘張馨月’,’計算機應用’,’講師’,’計算機學院’)和(‘06018’, ‘李誠’,’機械制造’,’副教授’,’機械學院’)，并查看插入數(shù)據(jù)情況。CREATE VIEW v_avgstuASSELECT TOP 100 ,sname,avg(final) AS 39。計算機學院39。) 視圖與索引使用SQL語言1. 創(chuàng)建一個視圖v_teacher，查詢所有“計算機學院”的教師信息, 添加WITH CHECK OPTION選項。InSELECT * FROM teacherWHERE teacherno IN (SELECT teacherno FROM teach_class WHERE courseno=39。表：student,scoreSELECT ,sname,AVG(final) AS 平均分FROM student JOIN score ON =WHERE final IS NOT NULL and final =80GROUP BY ,snameHAVING COUNT(*)=2SQL語句的高級應用2 – 使用子查詢3. 查詢?nèi)雽W考試成績最高的學生的學號、姓名和入學成績。 AND final IS NOT NULLGROUP BY coursenoHAVING COUNT(studentno)=3 AND AVG(final)=75ORDER BY AVG(final) DESC SQL語句的高級應用1 – 內(nèi)連接、外連接1. 查詢所有班級的期末成績平均分，并按照平均分降序排列。SELECT courseno,COUNT(studentno) AS 選修人數(shù), AVG(
教學教案相關推薦
鄂ICP備17016276號-1