下列SQL语句中,能够完成求某列最大值的是()。
A: SELECT AVG(Age) FROM Student
B: SELECT MAX(Age) FROM Student
C: SELECT MIN(Age) FROM Student
D: SELECT COUNT(*) FROM Student
A: SELECT AVG(Age) FROM Student
B: SELECT MAX(Age) FROM Student
C: SELECT MIN(Age) FROM Student
D: SELECT COUNT(*) FROM Student
举一反三
- 下列SQL语句中,能够完成求某列最大值的是()。 A: ASELECT AVG(Age) FROM Student B: BSELECT MAX(Age) FROM Student C: CSELECT MIN(Age) FROM Student D: DSELECT COUNT(*) FROM Student
- 下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。( ) A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);
- 统计学生成绩中的最高分,下列语句正确的是 A: SELECT AVG(grade) FROM student; B: SELECT (SUM(grade) / Count(id)) FROM student; C: SELECT MAX(grade) FROM student; D: SELECT MIN(grade) FROM student;
- 数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中年龄介于20和30岁之间的数据,下列哪个SQL语句是正确的?() 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"
- 对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁至22岁之间的学生的姓名和学号的语句是( )。 A: SELECT*FROM student WHERE age BETWEEN 20 AND 22 B: SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22 C: SELECT sname,sno FROM student WHERE age>=20 D: SELECT sname,sno FROM student WHERE age<=22