【正文】
Select distinct depart from teacher2.選擇查詢l 查詢性別為‘女’或年齡在20歲的學(xué)生記錄Select * from studentWhere ssex=’女’or sage=20l 查詢成績?yōu)?5或86的記錄Select * from scoreWhere degree in (85,86)l 以班號降序顯示學(xué)生表的所有記錄Select * From studentOrder by sclass descl 查詢各門課程的最高分Select o,max(degree)From scoreWhere not degree is nullGroup by ol 查詢所有學(xué)生的學(xué)號、選修的課程號及成績Select sno,ame,degreeFrom score,courseWhere =l 查詢各班學(xué)生所選課程的平均分Select sclass,avg(degree) from student,scoreWhere =Group by sclassl 查詢選修某課程的學(xué)生人數(shù)多于5人的教師姓名Select tnameFrom teacherWhere tno in (select From course x,score y Where = Group by Hav