注意:此页面搜索的是所有试题
题目内容
(国家开放大学MySQL数据库应用)
表A中有字段b,类型为int,100条记录,值分别为1至100。如下语句
SELECT b FROM A
WHERE b BETWEEN 1 AND 50OR (b IN (25,70,95)AND b BETWEEN 25 AND 75)
则如下哪个值在这个sql语句返回的结果集中(A )
A.30 B.51
C.75 D.95
SELECT b FROM A
WHERE b BETWEEN 1 AND 50OR (b IN (25,70,95)AND b BETWEEN 25 AND 75)
则如下哪个值在这个sql语句返回的结果集中(A )
A.30 B.51
C.75 D.95
参考答案