国家开放大学 / 数据库应用技术
现要利用Student表查询年龄最小的学生姓名和年龄。下列实现此功能的查询语句中,正确的是( )。
a. SELECT Sname, MIN(Sage) FROM Student
b. SELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage)
c. SELECT TOP 1 Sname, Sage FROM Student
d. SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage
a. SELECT Sname, MIN(Sage) FROM Student
b. SELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage)
c. SELECT TOP 1 Sname, Sage FROM Student
d. SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage
参考答案:
佳题速递: