以下各项中，不符合《商业银行开办代客境外理财业务管理暂行办法》的有关规定的是（)。 A. 商业银行

根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用？()

A select * from student where age< avg(age)

B select * from student having age< avg(age)

C select * from student a where a.age< (select avg(b.age) from student b)

D select * from student a where (select avg(b.age) from student b ) >= a.age

根据SQL标准，下面哪句语句能够找出年龄最小的同学？其中age为学生表student中的年龄字段，sno为学生的学号。()

A select max(age) from student

B select sno from student where age = max(age)

C select sno from student having age = max(age)

D select sno from student a where a.age<= (select min(b.age) from student b)

A select max(age) from student

B select sno from student where age = max(age)

C select sno from student having age = max(age)

D select sno from student a where a.age<= (select min(b.age) from student b)

A delete from student

B delete all from student

C delete * from student

D drop table student

A select dept,avg(age) from student where avg(age)<21

B select dept,avg(age) from student group by dept having avg(age)<21

C select dept,avg(age) from student having avg(age)<21

D select dept,avg(age) from student group by dept where avg(age)<21

根据SQL标准，修改表的数据结构，下面哪种语句适用？()

A UPDATE

B ALTER

C CHANGE

D SHIFT

根据SQL标准，删除一个表中的记录，下面哪个语句适用？()

A DROP TABLE

B DROP

C DELETE

D ERASE

有学生信息表student，求年龄在20～22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是

SELECT sname，age FROM student

WHERE age【 】；

将学生表Student中的学生年龄(字段名是AGE)增加1岁，应该使用的SQL命令是：

UPDATE Student______

有学生信息表student，求年龄在20岁到22岁之间(含20岁和22岁)的学生姓名和年龄的 SQL语句是：

SELECT sname, age FROM student

WHERE age ______；