orcale中between and的sql语句怎么写啊！求大神指导

Question

就是我想查询数据库中name列里随便一个范围内的数据
该怎么写呢，

Answer 1

你的name是什么类型的？

字符串的话只能用枚举了。 name in ('a','b','c')

如果是说数字类型或者日期时间类型，可以用 between and 或者 > < 当然也可以枚举

举例如下：

字段类型： name varchar2(30), age int(3)

select * from tableName where name = 'a' ;
select * from tableName where name in ('a','b','c')

select * from tableName where age = 100
select * from tableName where age between 10 and 20
select * from tableName where age > 10 and age < 20
select * from tableName where age in (20,30) -- 等价于 age = 20 or age = 30