欢迎来到牛牛题库网 牛牛题库官网
logo

单项选择题

从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

点击查看答案&解析
微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题