单项选择题
从Student表中选取年龄最大的五名男同学的方法是: A.
SELECT StudentName AS '姓名', YEAR(Birth) AS '年龄'
FROM Student
WHERE (Sex = '男')
ORDER BY '年龄' B.
SELECT StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄'
FROM Student
WHERE (Sex = '男')
ORDER BY '年龄' C.
SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄'
FROM Student
WHERE (Sex = '男')
ORDER BY '年龄' D.
SELECT TOP (5) StudentName AS '姓名', 2021 - YEAR(Birth) AS '年龄'
FROM Student
WHERE (Sex = '男')
ORDER BY '年龄' DESC
点击查看答案&解析
