A表字段a 类型int中有100条记录,值分别为1至100。如下语句 SELECT a FROM A WHERE a BETWEEN 1 AND 50 OR (a IN (25,70,95) AND a BETWEEN 25 AND 75) 则如下哪个值在这个sql语句返回的结果集中?
发布于 2022-03-03 17:18:52
A表字段a 类型int中有100条记录,值分别为1至100。如下语句 SELECT a FROM A WHERE a BETWEEN 1 AND
50 OR (a IN (25,70,95) AND a BETWEEN 25 AND 75)
则如下哪个值在这个sql语句返回的结果集中?
登录后免费查看答案
关注者
0
被浏览
80