在( )子查询中,内层查询只处理一次,得到一个结果集,再依次处理外层查询
A. In子查询
B. Exist子查询
C. Not Exist子查询
D. Join子查询
查看答案
与Where G Between 60 And 100语句等价的子句是( )
A. Where G>60 And G<100
B. Where G>=60 And G<100
C. Where G>60 And G<=100
D. Where G>=60 And G<=100
在stud表中返回年龄最小的8位同学的信息,使用( )
A. SELECT * FROM studORDER BY birthday DESCLIMIT 8;
B. SELECT * FROM studORDER BY birthday ASCLIMIT 8;
C. SELECT * FROM studORDER BY birthday ASCLIMIT 7;
D. SELECT * FROM studORDER BY birthday DESCLIMIT 7;
模式查找Like '_A%',下面哪个结果是可能的( )
Aili
Bai
C. Bba
D. Cca
SQL语言中,条件表示年龄不在40至50(不包括40和50)之间的表达式为 ( )
A. In (40,50)
B. not Between 40 And 50
C. not Between 39 Or 51
D. not Between 41 ,51