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)
第1题
根据SQL标准,要删除表student中所有数据,但不将表student的定义一起删除,下面哪个语句可以适用?()
A delete from student
B delete all from student
C delete * from student
D drop table student
第3题
根据SQL标准,把表SC1中的记录复制到另一个表SC2中,其中SC1表和SC2表的字段定义完全一样。下面哪条语句适用?()
A copy * from SC1 to SC2
B copy * from SC2 to SC1
C insert into SC2 select * from SC1
D insert into SC1 select * from SC2
第4题
根据SQL标准,下面哪条语句与select min(age) from student等效?()
A select age from student where age >= min(age)
B select distinct age from student where age >= all min(age)
C select distinct a.age from student a where a.age<= any (select distinctb.age from student b)
D select distinct a.age from student a where a.age<= all (select distinct b.age from student b)
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!