展开全部
大于等于52610小于等于100,表达式为X>=0 and X<=100,4102或者用另一种写法1653X between 0 and 100;
举例如下:版
1、创建测试表,
create table test_range(id varchar2(20),value varchar2(20));
2、插入权测试数据;
insert into test_range values(1, 123);
insert into test_range values(2, 5);
insert into test_range values(3, 100);
insert into test_range values(4, -5);
insert into test_range values(5, 0);
commit;
3、查询表中全量数据;select t.*, rowid from test_range t;
4、编写语句,只查询value为大于等于0小于等于100的记录;
select t.*, rowid sec from test_range t where value between 0 and 100;