實驗報告2關(guān)系數(shù)據(jù)庫標準語言sql-在線瀏覽
2024-08-24 20:00本頁面
【正文】 39。吳華39。女39。成都39。計算機系39。110239。張軍39。男39。上海39。工程系39。1SELECT DISTINCT Sno 39。FROM Student_course。學(xué)號39。出生年份39。3SELECT Sno 39。, Sname 39。FROM StudentWHERE Sdept = 39。4SELECT Sname 39。, Sage 39。FROM StudentWHERE Sage =20 and Sage = 22。%波%39。學(xué)號39。課程號39。7SELECT Sno 39。, Grade 39。FROM Student_courseWHERE Cno = 39。ORDER BY Grade DESC。9SELECT AVG(Grade)FROM Student_courseWHERE Cno = 39。10SELECT Sno 39。FROM Student_courseGROUP BY SnoHAVING COUNT(Cno) 2。課程號39?？偡?9。12SELECT , FROM Student,Student_course,CourseWHERE = and = and = 39。 and 80。14SELECT Sname, Sdept, SageFROM StudentWHERE Sage ANY(SELECT Sage FROM Student WHERE Sdept = 39。)。課程號39。課程名39。劉劍平39。教師39。
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1