99999久久久久久亚洲,欧美人与禽猛交狂配,高清日韩av在线影院,一个人在线高清免费观看,啦啦啦在线视频免费观看www

熱線電話：13121318867

登錄
2021-05-31 閱讀量: 2570
如何查詢各科成績最高和最低的分：以如下形式顯示：課程ID，最高分，最低分

SELECT L.C# As 課程ID,L.score AS 最高分,R.score AS 最低分


FROM SC L ,SC AS R


WHERE L.C# = R.C# and


L.score = (SELECT MAX(IL.score)


FROM SC AS IL,Student AS IM


WHERE L.C# = IL.C# and IM.S#=IL.S#


GROUP BY IL.C#)


AND


R.Score = (SELECT MIN(IR.score)


FROM SC AS IR


WHERE R.C# = IR.C#


GROUP BY IR.C#


);


55.8911
0
關(guān)注作者
收藏
評論(0)

發(fā)表評論

暫無數(shù)據(jù)
推薦帖子