NeoYang 發表於 2008-11-11 15:56:26

SQL 2008/11/11

01.在classes資料表中找出有幾位學生選修CS213Select Count(*) From Classes Where c_no = 'CS213'02.在classes表中統計每一間教室提供給幾門課程表作為教室Select room,Count(*) From Classes Group By room03.找出教授兩門課程以上的老師名單Select name from Instructors
Where Exists(
Select eid,Count(*) From Classes
Where Classes.eid = Instructors.eid Group By eid
Having Count(*) >= 2)
頁: [1]
查看完整版本: SQL 2008/11/11

Checking the Pageranks