现要利用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
A、A.查询年龄大于20并且小于等于25的学生 B、B.查询年龄大于20并且小于25的学生 C、C.查询年龄大于等于20并且小于等于25的学生 D、D.查询年龄大于等于20并且小于25的学生
A、Select* From Student Where Age>=20 ANDAge>=30 B、Select* From Student Where Age>=20 ANDAge<=30 C、Select* From Student Where Age BET WENN 20AND30 D、Select* From Student Where Age>=20&&Age>=30"
A、年龄:Now()-Year(″出生年月″) B、年龄:Year(Now())-Year([出生年月]) C、年龄:Year(Now())-Year(#出生年月#) D、年龄:Year(Now())-Year(′出生年月′)