數(shù)據(jù)庫(kù)實(shí)驗(yàn)指導(dǎo)書(shū)(5746)(編輯修改稿)
2025-08-31 00:12 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 /*方法二*/USE jiaoxuedbSELECT ,FROM jiaoxuedbdent s1, jiaoxuedbdent s2WHERE = AND =39。張建國(guó)39。 AND 39。張建國(guó)39。10. 查詢選修了2門(mén)以上課程的學(xué)生名單。USE jiaoxuedbSELECT Sno AS 學(xué)號(hào),Sname AS 姓名,Age AS 年齡,Dept AS 專(zhuān)業(yè)FROM jiaoxuedbdentWHERE Sno=ANY (SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) =2)GO11. 查詢至少有一門(mén)與“張建國(guó)”選課相同的學(xué)生的姓名、課程名和系別。USE jiaoxuedbSELECT Sno AS 學(xué)號(hào),Sname AS 姓名,Age AS 年齡,Dept AS 專(zhuān)業(yè)FROM jiaoxuedbdentWHERE Sno=ANY (SELECT Sno FROM SC WHERE Cno=ANY (SELECT Cno FROM SC WHERE Sno=’991103’)) AND Sname 39。張建國(guó)39。GO12. 查詢成績(jī)比該課程平均成績(jī)高的學(xué)生的成績(jī)表。/*方法一*/USE jiaoxuedbSELECT *FROM Sc xWHERE Score (SELECT AVG(Score) FROM SC y WHERE =))。GO/*方法二*/SELECT *FROM SC sc1WHERE Score (SELECT AVG(Score) FROM SC sc2) AND =。GO13. 查詢選修課號(hào)為01001課程且成績(jī)高于課程01002學(xué)生的成績(jī)姓名、此兩門(mén)課程的選修課程名和成績(jī)。/*方法一*/USE jiaoxuedbSELECT Sname,Cname,ScoreFROM jiaoxuedbdent ,SC,CourseWHERE in (SELECT FROM SC s1,SC s2 WHERE =39。0100139。 AND =39。0100239。 AND AND =) AND = AND =GO/*方法二*/USE jiaoxuedbSELECT Sname,Cname,ScoreFROM jiaoxuedbdent ,SC,CourseWHERE in (SELECT Sno FROM SC x WHERE Score = (SELECT AV
高考資料相關(guān)推薦
鄂ICP備17016276號(hào)-1