單項(xiàng)選擇題

在學(xué)生選課表(SC)中,查詢選修了3號課程(課程號CH)的學(xué)生的學(xué)號(XH)及其成績(GD)。查詢結(jié)果按分?jǐn)?shù)的降序排列。實(shí)現(xiàn)該功能的正確SQL語句是()

A.SELECT XH,GD FROM SC WHERE CH=’3’ORDER BY GDDESC
B.SELECT XH,GD FROM SC WHERE CH=’4’ORDER BY GDASC
C.SELECT XH,GD FROM SC WHERE CH=’5’GROUP BY GDDESC
D.SELECT XH,GD FROM SC WHERE CH=’6’GROUP BY GDASC

微信掃碼免費(fèi)搜題