从Student表中选取年龄最大的五名男同学的方法是： A. SELE...
单项选择题从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
