論壇 › PHP討論區 › SQL 2008/12/09

NeoYang 發表於 2008-12-9 16:25:13

SQL 2008/12/09

第一題:找出在Classes表中 沒有選課紀錄的學生名字Select name From Students
Where Not Exists(
        Select * From Classes
        Where Classes.sid = Students.sid
)第二題:找出'李鴻章'開設所有課之學生名字Select name From Students
Where Not Exists(
        (Select c_no From Instructors,Classes
        Where name = '李鴻章' And Instructors.eid = Classes.eid
        )Except(
        Select c_no From Classes
        Where Students.sid = Classes.sid)
)第三題:更新Classes資料表 講師'李鴻章'上課教室'500-K'改為'300-K'Update Classes Set Classes.room = '300-K'
From Classes Inner Join Instructors On Classes.eid = Instructors.eid
Where Instructors.name = '李鴻章' And Classes.room = '500-K'

查看完整版本: SQL 2008/12/09