单表查询

带in关键字的查询

select *
from a123.fruits
where s_id in (200,2001,2382); -- 查询范围为括号内的值

查询结果

带between and 的区间查询

select *
from a123.fruits
where s_id between 1005 and 1009; -- 区间范围为括号中的值

查询结果