国家开放大学 / 数据库应用技术
4. 现要利用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
参考答案:
佳题速递: