Question

SQL between 不包含

select * from [成绩表] where [分数] between 0 and 60
这个语句是结果是 0 <= 分数 <= 60

要求查询的数据是 0 < 分数 < 60 应该怎么查?
也就是说,分数应该在 0.00000000```1 到 59.99999999```9 分之间.

Answer 1

between and 是闭的，只能这样

select * from [成绩表] where [分数] 〉 0 and [分数] <60
或者
select * from [成绩表] where [分数] between 0 and 60
except
select * from [成绩表] where [分数] = 0 or [分数] = 60

Answer 2

有办法，只能这样写：
select * from [成绩表] where [分数] between 0 and 60 and [分数] not in (0,60)

这样是不是有点画蛇添足了吧，还不如大于小于的方法吧

Answer 3

select * from [成绩表] where [分数]>0 and [分数]< 60

追问

我的意思是 有没有 用 between 就直接不含的写法??

这个语句我懂

追答

呵呵。用between实现不了您的需求。between and 的语法含义就是这样。