本帖最后由 philinip 于 2021-6-2 12:02 编辑
谢谢回复,表名称test1, 表结构和数据如下
create table test1( fphm varchar2(10), kshm varchar2(10) ) insert all into test1(fphm,kshm) values('2014','00000001') into test1(fphm,kshm) values('2014','00000002') into test1(fphm,kshm) values('2014','00000003') into test1(fphm,kshm) values('2014','00000004') into test1(fphm,kshm) values('2014','00000005') into test1(fphm,kshm) values('2014','00000007') into test1(fphm,kshm) values('2014','00000008') into test1(fphm,kshm) values('2014','00000009') into test1(fphm,kshm) values('2013','00000120') into test1(fphm,kshm) values('2013','00000121') into test1(fphm,kshm) values('2013','00000122') into test1(fphm,kshm) values('2013','00000124') into test1(fphm,kshm) values('2013','00000125') select * from dual; Commit; 问题就是 查询2的结果应该是查询1的子集,为什么ST不一致 |