有课程表Course (Cno,Cname,Cred),其中:C Cno为课程号,Cname为课程名,Cred为学分。查询 “学分”最高的前两门课,正确的T-SQL语句为( )。
选项:
A:SELECT TOP 2 * FROM Course
B:SELECT TOP 2 * FROM Course WHERE CRED=MAX(Cred)
C:SELECT TOP 2 * FROM Course ORDER BY Cred DESC
D:SELECT TOP 2 * FROM Course WHERE CRED=(SELECT MAX(Cred) FROM Course)
发布时间:2024-05-10 21:43:09